欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 切换日志: Fri Nov 24 11:30:43 2006 alter database commit to switchover to physical standby with session shutdown Fri Nov 24 11:30:43 2006 ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICA
欢迎进入oracle社区论坛，与200万技术人员互动交流 >>进入
切换日志:
Fri Nov 24 11:30:43 2006alter database commit to switchover to physical standby with session shutdownFri Nov 24 11:30:43 2006ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBYFri Nov 24 11:30:43 2006SMON: disabling tx recoveryFri Nov 24 11:30:44 2006Active process 26743 user 'oracle' program 'oracle@wapcom1.hawa.cn (CJQ0)'Active process 9033 user 'oracle' program 'oracle@wapcom1.hawa.cn (TNS V1-V3)'Active process 7655 user 'oracle' program 'oracle@wapcom1.hawa.cn (TNS V1-V3)'...............Active process 8944 user 'oracle' program 'oracle@wapcom1.hawa.cn (TNS V1-V3)'Active process 29104 user 'oracle' program 'oracle@wapcom1.hawa.cn (TNS V1-V3)'Active process 30750 user 'oracle' program 'oracle@wapcom1.hawa.cn (TNS V1-V3)'Active process 9045 user 'oracle' program 'oracle@wapcom1.hawa.cn (TNS V1-V3)'CLOSE: waiting for server sessions to complete.Fri Nov 24 11:31:51 2006CLOSE: all sessions shutdown successfully.Fri Nov 24 11:32:09 2006SMON: disabling cache recoveryFri Nov 24 11:32:10 2006Shutting down archive processesArchiving is disabledFri Nov 24 11:32:10 2006ARCH shutting downFri Nov 24 11:32:10 2006ARCH shutting downFri Nov 24 11:32:10 2006ARC0: Archival stoppedFri Nov 24 11:32:10 2006ARC1: Archival stoppedFri Nov 24 11:32:10 2006Thread 1 closed at log sequence 6076Successful close of redo thread 1Fri Nov 24 11:32:28 2006ARCH: noswitch archival of thread 1, sequence 6076ARCH: End-Of-Redo archival of thread 1 sequence 6076ARCH: Evaluating archive log 3 thread 1 sequence 6076ARCH: Beginning to archive log 3 thread 1 sequence 6076Creating archive destination LOG_ARCHIVE_DEST_2: 'bmarksb'Creating archive destination LOG_ARCHIVE_DEST_1: '/var/oradata/arch/1_6076.arc'ARCH: Completed archiving log 3 thread 1 sequence 6076ARCH: archiving is disabled due to current logfile archivalClearing standby activation ID 3520937155 (0xd1dd3cc3)The primary database controlfile was created using the'MAXLOGFILES 5' clause.The resulting standby controlfile will not have enoughavailable logfile entries to support an adequate numberof standby redo logfiles. Consider re-creating theprimary controlfile using 'MAXLOGFILES 8' (or larger).Use the following SQL commands on the standby database to createstandby redo logfiles that match the primary database:ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 10485760;ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 10485760;ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 10485760;ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 10485760;Archivelog for thread 1 sequence 6076 required for standby recoveryMRP0 started with pid=8MRP0: Background Managed Standby Recovery process startedMedia Recovery Log /var/oradata/arch/1_6076.arcIdentified end-of-REDO for thread 1 sequence 6076Identified end-of-REDO for thread 1 sequence 6076Media Recovery End-Of-Redo indicator encounteredMedia Recovery Applied until change 194025715MRP0: Media Recovery Complete: End-Of-REDOResetting standby activation ID 3520937155 (0xd1dd3cc3)MRP0: Background Media Recovery process shutdownFri Nov 24 11:32:35 2006Switchover: Complete - Database shutdown requiredCompleted: alter database commit to switchover to physical stFri Nov 24 11:32:53 2006Shutting down instance: further logons disabledShutting down instance (immediate)License high water mark = 140Fri Nov 24 11:32:53 2006ALTER DATABASE CLOSE NORMALORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...ARCH: Archiving is disabledShutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeARCH: Archiving is disabledShutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeFri Nov 24 11:33:14 2006Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0SCN scheme 2Using log_archive_dest parameter default valueLICENSE_MAX_USERS = 0SYS auditing is disabledStarting up ORACLE RDBMS Version: 9.2.0.6.0.System parameters with non-default values:processes = 150timed_statistics = TRUEshared_pool_size = 83886080large_pool_size = 33554432standby_archive_dest = /var/oradata/archfal_server = bmarksbfal_client = bmarklog_archive_format = %t_%s.arc...........CJQ0 started with pid=8Fri Nov 24 11:33:15 2006ARCH: STARTING ARCH PROCESSESARC0 started with pid=9ARC0: Archival startedARC1 started with pid=10Fri Nov 24 11:33:15 2006ARCH: STARTING ARCH PROCESSES COMPLETEFri Nov 24 11:33:15 2006ARC1: Archival startedFri Nov 24 11:33:15 2006ARC0: Thread not mountedFri Nov 24 11:33:15 2006ARC1: Thread not mountedFri Nov 24 11:33:22 2006alter database mount standby databaseFri Nov 24 11:33:26 2006Successful mount of redo thread 1, with mount id 3559140162Fri Nov 24 11:33:26 2006Standby Database mounted.Completed: alter database mount standby databaseFri Nov 24 11:33:29 2006ALTER DATABASE RECOVER managed standby database disconnect Attempt to start background Managed Standby Recovery processMRP0 started with pid=12MRP0: Background Managed Standby Recovery process startedFri Nov 24 11:33:34 2006Completed: ALTER DATABASE RECOVER managed standby database dFri Nov 24 11:33:34 2006Media Recovery Waiting for thread 1 seq# 6077Media Recovery Log /var/oradata/arch/1_6077.arcMedia Recovery Waiting for thread 1 seq# 6078Media Recovery Log /var/oradata/arch/1_6078.arcMedia Recovery Waiting for thread 1 seq# 6079
看来以后不能再采购联志服务器了。
-The End-
http://www.eygle.com/archives/2006/11/aisino_server_dataguard.html
[1] [2]
