一次vm虚拟机时间倒流而导致的oracle数据库启动故障-mysql教程-PHP中文網

首頁

資料庫

mysql教程

一次vm虚拟机时间倒流而导致的oracle数据库启动故障

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:00 PM

oracle啟動導致資料庫時間虛擬機

一次vm 虚拟机时间倒流而导致的oracle 数据库启动故障本文是原创文章，若转载请注明出处： http://blog.csdn.net/msdnchina/article/details/38782163 直接上数据库的alert日志： Fri Apr 25 22:00:54 2014 -----注意该时间Archived Log entry 1766 added f

一次vm 虚拟机时间倒流而导致的oracle 数据库启动故障

本文是原创文章，若转载请注明出处：

http://blog.csdn.net/msdnchina/article/details/38782163

直接上数据库的alert日志：

Fri Apr 25 22:00:54 2014  <-----注意该时间
Archived Log entry 1766 added for thread 1 sequence 1770 ID 0x4e0785c3 dest 1:
Sun Sep 02 23:04:52 2012  <-----注意该时间
Starting ORACLE instance (normal)
************************ Large Pages Information *******************
Per process system memlock (soft) limit = 32 KB
 
Total Shared Global Region in Large Pages = 0 KB (0%)
 
Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
 
RECOMMENDATION:
  Total System Global Area size is 4226 MB. For optimal performance,
  prior to the next instance restart:
  1. Increase the number of unused large pages by 
 at least 2113 (page size 2048 KB, total size 4226 MB) system wide to
  get 100% of the System Global Area allocated with large pages
  2. Large pages are automatically locked into physical memory.
 Increase the per process memlock (soft) limit to at least 4234 MB to lock
 100% System Global Area&#39;s large pages into physical memory
********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
    NUMA status: non-NUMA system
    cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
    Grp 0: 
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /opt/oracle/product/11g/dbname_1
System name: Linux
Node name: oracle
Release: 2.6.18-371.el5
Version: #1 SMP Thu Sep 5 21:21:44 EDT 2013
Machine: x86_64
VM name: VMWare Version: 6
Using parameter settings in server-side spfile /opt/oracle/product/11g/dbname_1/dbs/spfileorcl.ora
System parameters with non-default values:
  processes                = 300
  sessions                 = 472
  nls_language             = "SIMPLIFIED CHINESE"
  nls_territory            = "CHINA"
  sga_target               = 4224M
  control_files            = "/oracledata/orcl/control01.ctl"
  control_files            = "/opt/oracle/fast_recovery_area/orcl/control02.ctl"
  control_files            = "/oracledata/orcl/control03.ctl"
  control_files            = "/oracledata/orcl/control04.ctl"
  control_files            = "/oracledata/orcl/control05.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.4.0"
  log_archive_format       = "%t_%s_%r.dbf"
  db_files                 = 2000
  db_recovery_file_dest    = "/opt/oracle/fast_recovery_area"
  db_recovery_file_dest_size= 40G
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  audit_file_dest          = "/opt/oracle/admin/orcl/adump"
  audit_trail              = "DB"
  db_name                  = "orcl"
  open_cursors             = 300
  pga_aggregate_target     = 1403M
  deferred_segment_creation= FALSE
  diagnostic_dest          = "/opt/oracle"
Sun Sep 02 23:04:53 2012
PMON started with pid=2, OS id=4452 
Sun Sep 02 23:04:53 2012
PSP0 started with pid=3, OS id=4454 
Sun Sep 02 23:04:54 2012
VKTM started with pid=4, OS id=4456 at elevated priority
Sun Sep 02 23:04:54 2012
GEN0 started with pid=5, OS id=4460 
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sun Sep 02 23:04:54 2012
DIAG started with pid=6, OS id=4462 
Sun Sep 02 23:04:54 2012
DBRM started with pid=7, OS id=4464 
Sun Sep 02 23:04:54 2012
DIA0 started with pid=8, OS id=4466 
Sun Sep 02 23:04:54 2012
MMAN started with pid=9, OS id=4468 
Sun Sep 02 23:04:54 2012
DBW0 started with pid=10, OS id=4470 
Sun Sep 02 23:04:54 2012
LGWR started with pid=11, OS id=4472 
Sun Sep 02 23:04:54 2012
CKPT started with pid=12, OS id=4474 
Sun Sep 02 23:04:54 2012
SMON started with pid=13, OS id=4476 
Sun Sep 02 23:04:54 2012
RECO started with pid=14, OS id=4478 
Sun Sep 02 23:04:55 2012
MMON started with pid=15, OS id=4480 
Sun Sep 02 23:04:55 2012
MMNL started with pid=16, OS id=4482 
starting up 1 dispatcher(s) for network address &#39;(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))&#39;...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /opt/oracle
Sun Sep 02 23:04:55 2012
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 1320728727
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Sun Sep 02 23:04:59 2012
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
 parallel recovery started with 3 processes
Started redo scan
Completed redo scan
 read 69 KB redo, 66 data blocks need recovery
Started redo application at
 Thread 1: logseq 1771, block 16853
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1771 Reading mem 0
  Mem# 0: /oracledata/orcl/redo01.log
Completed redo application of 0.04MB
Completed crash recovery at
 Thread 1: logseq 1771, block 16992, scn 13030631482598
 66 data blocks read, 66 data blocks written, 69 redo k-bytes read
************************************************************
Warning: The SCN headroom for this database is only -652 hours!
************************************************************
Errors in file /opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4492.trc  (incident=43353):
ORA-00600: internal error code, arguments: [kcm_headroom_warn_1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/orcl/orcl/incident/incdir_43353/orcl_ora_4492_i43353.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4492.trc:
ORA-00600: internal error code, arguments: [kcm_headroom_warn_1], [], [], [], [], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Dumping diagnostic data in directory=[cdmp_20120902230501], requested by (instance=1, osid=4492), summary=[incident=43353].
Sun Sep 02 23:05:58 2012
Sweep [inc][43353]: completed
Sweep [inc2][43353]: completed
Sun Sep 02 23:19:58 2012
db_recovery_file_dest_size of 40960 MB is 29.05% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sun Sep 02 23:38:25 2012

陳述

本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn

如何修复 Windows 11 中的 Hypervisor 错误Apr 16, 2023 pm 12:37 PM

对于许多用户来说，Windows有一个隐藏的内置功能，可用于轻松创建和管理虚拟机。此功能称为Hypervisor或Hyper-V。但与其他Windows功能一样，此功能并非完全没有错误。在本文中，我们将向您展示如何轻松快速地解决Hyper-V问题。因此，事不宜迟，让我们立即进入解决方案，让虚拟机启动并运行。修复1–检查您的系统是否支持Hyper-V您应该尝试的第一件事是检查系统是否支持Hyper-V并且仍然处于激活状态。1.您必须重新启动系统。要安全地执行此操作，请按一次Wi

使用 VirtualBox 在 Windows 11 上安装 Windows XP ISOMay 05, 2023 pm 02:25 PM

Windows11VirtualBox虚拟机上的WindowsXP此处给出的使用VirtualBox安装WindowsXPISO映像的步骤不仅限于Windows11。用户可以在Linux（例如Ubuntu、macOS、Windows10、7或他们正在使用并拥有Virtualbox的其他操作系统）上遵循这些步骤。下载WindowsXPISOWindowsXP已由Microsoft存档，其ISO与产品密钥一起由他们在Archive.org上正式

如何修复 VMMEM 高内存和 CPU 使用率Apr 18, 2023 pm 04:40 PM

由于各种因素，Vmmem或虚拟内存可能会导致高CPU或内存使用率。此问题背后的关键原因之一是虚拟主机中运行的一些资源密集型进程。但是，如果不是这种情况，并且VM在空闲模式下仍然占用大量系统资源，则可能是驱动程序故障。这会降低虚拟机的速度，并且您的工作可能会停止。因此，请按照以下步骤快速解决问题。修复1–结束所有资源密集型进程如果您正在运行一些繁重的应用程序或软件版本，则预计vmmem会使用大量资源。这没有什么异常。即使您可以直接终止这些进程，也可以为您的设备释放更多资源。注意–您可以通

适用于Windows 11的最佳虚拟机（免费和付费）Apr 13, 2023 am 11:40 AM

虚拟机或虚拟机是一种模拟计算机并替代真实事物的软件。VM 模仿计算机的硬件和体系结构以提供相同的功能。你可以在虚拟机上运行现有的应用和服务，而不必冒常规电脑稳定性的风险。例如，Windows 11现在有很多错误，可能会使体验令人沮丧。虚拟机将允许人们试用它而无需注册任何东西。请继续阅读，了解哪个是适合您需求和愿望的最佳 Windows 11 虚拟机。什么是适用于 Windows 11 的最佳虚拟机？VMware 工作站VMware Workstation是市场上最好的虚拟机之一，因为它具有高度的

如何在 Windows 11 上安装和使用 VirtualBox：2022详细的分步教程Apr 14, 2023 pm 11:43 PM

自发布以来，Windows11经历了相当大的起伏。该操作系统现在更加稳定，并且具有许多似乎可以适应大多数用户的变化。Windows作为一个平台一直是通用的，能够创建虚拟机、驱动器、硬件设备等。这有助于内部测试、在不同环境中编码，或者只是一些好的旧修补。如果您一直希望在Windows11上模拟或虚拟化平台，那么VirtualBox是您的绝佳选择。让我们进一步了解它！什么是VirtualBox？VirtualBox是一款历史悠久的虚拟化软件，自发布以来一直受到大多数用户的青睐。目前由Ora

VMWare Workstation Fix 中没有足够的物理内存可用Apr 20, 2023 pm 03:43 PM

VMWare上的虚拟机需要大量物理内存才能正常运行和运行。RAM是虚拟机的重要组成部分，如果没有足够数量的物理RAM可用，它甚至无法启动并抛出一个长错误消息“没有足够的物理内存来启动此虚拟机”。正如错误消息所暗示的，这是系统中物理内存不足的结果。解决方法——1.您应该做的第一件事是重新启动系统。这显然会为主机清除一些额外的内存。重启后直接启动VMWare，启动虚拟机。2.如果你有另一个虚拟机，尝试运行它并测试。修复1–编辑config.ini文件您可以编辑配置文件，以便虚拟机仅使用系统可

Windows 11 ARM 在 UTM 虚拟机中在 Apple M1 上的惊人运行速度Apr 22, 2023 am 08:55 AM

Windows11架构：ARM64内存：8GB磁盘：20GiB显示：VGASPICE工具：已安装本教程仅适用于AppleSiliconMac。下载适用于Mac的UTM适用于ARM的WindowsSPICE访客工具指示打开UTM并单击“+”按钮以打开VM创建向导。选择“虚拟化”。选择“窗口”。单击“浏览”并选择上面下载的WindowsVHDX。按“下一步”继续。选择您希望授予VM访问权限的RAM和CPU内核数量。按“下一步”继续。如果你有一个目录要挂载到V

虚拟机对电脑伤害大吗？Sep 08, 2023 pm 05:29 PM

虚拟机对电脑伤害不大。原因是虚拟机一般不会对电脑造成直接的伤害。虚拟机是一种软件工具，允许在一台物理计算机上创建和运行多个虚拟的操作系统环境，它通过在主机操作系统上模拟硬件和资源来实现，如果虚拟机配置不当或资源分配不合理，可能会导致主机计算机的性能下降或出现不稳定的情况，此外，虚拟机也可能会在主机计算机上占用较多的存储空间。因此，在使用虚拟机时，建议合理配置虚拟机的资源。

See all articles