关于Oracle Data Guard的角色切换(二)
Wed Apr 1014:39:45 2013
Stoppingbackground process CJQ0
Wed Apr 1014:39:45 2013
SMON:disabling tx recovery
Wed Apr 1014:39:45 2013
Stoppingbackground process QMNC
Wed Apr 1014:39:47 2013
StoppingJob queue slave processes, flags = 27
Wed Apr 1014:39:47 2013
Job queueslave processes stopped
Waiting fordispatcher 'D000' to shutdown
Alldispatchers and shared servers shutdown
Wed Apr 1014:39:49 2013
SMON:disabling cache recovery
Wed Apr 1014:39:49 2013
Shuttingdown archive processes
Archivingis disabled
Wed Apr 1014:39:54 2013
ARCHshutting down
ARC1:Archival stopped
Wed Apr 1014:39:59 2013
ARCHshutting down
ARC0:Archival stopped
Wed Apr 1014:40:00 2013
Thread 1closed at log sequence 33
Successfulclose of redo thread 1
Wed Apr 1014:40:00 2013
ARCH:Noswitch archival of thread 1, sequence 33
ARCH:End-Of-Redo Branch archival of thread 1 sequence 33
ARCH:Archiving is disabled due to current logfile archival
Clearingstandby activation ID 1566058370 (0x5d582782)
The primarydatabase controlfile was created using the
'MAXLOGFILES40' clause.
There isspace for up to 37 standby redo logfiles
Use thefollowing SQL commands on the standby database to create
standbyredo logfiles that match the primary database:
ALTERDATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;
ALTERDATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;
ALTERDATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;
ALTERDATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;
Archivelogfor thread 1 sequence 33 required for standby recovery
Switchover:Primary controlfile converted to standby controlfile succesfully.
MRP0started with pid=15, OS id=15321
Wed Apr 1014:40:00 2013
MRP0:Background Managed Standby Recovery process started (tesdb)
ManagedStandby Recovery not using Real Time Apply
parallel recovery started with 16 processes
Onlinelogfile pre-clearing operation disabled by switchover
MediaRecovery Log +VG1/tesdb/archivelog/2013_04_10/thread_1_seq_33.330.812385601
IdentifiedEnd-Of-Redo for thread 1 sequence 33
Wed Apr 1014:40:06 2013
MediaRecovery End-Of-Redo indicator encountered
Wed Apr 1014:40:06 2013
MediaRecovery Applied until change 639287
Wed Apr 1014:40:06 2013
MRP0: MediaRecovery Complete: End-Of-REDO (tesdb)
Resettingstandby activation ID 1566058370 (0x5d582782)
Wed Apr 1014:40:07 2013
MRP0:Background Media Recovery process shutdown (tesdb)
Wed Apr 1014:40:07 2013
SUCCESS:diskgroup VG1 was dismounted
Wed Apr 1014:40:07 2013
Switchover:Complete - Database shutdown required (tesdb)
Wed Apr 1014:40:07 2013
Completed:alter database commit to switchover to physical standby
Wed Apr 1014:40:07 2013
idledispatcher 'D000' terminated, pid = (15, 1)
将数据库实例再重启一下，直接启动到read only状态了。
SQL>startup open
ORACLEinstance started.
Databasemounted.
Databaseopened.
SQL>conn test/test
Connected.
SQL>create table t1 as select * from all_objects