Implement Oracle Datagurad Switchover-ylw6006

水电工888

[oracle@dg1 ~]$ tail -f /u01/app/oracle/diag/rdbms/dg1/dg/trace/alert_dg.log　　Mon Apr 30 11:59:21 2012
　　alter database commit to switchover to physical standby

　　ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process>　　Mon Apr 30 11:59:21 2012
　　LGWR: Standby redo logfile selected to archive thread 1 sequence 19
　　LGWR: Standby redo logfile selected for thread 1 sequence 19 for destination LOG_ARCHIVE_DEST_2
　　Thread 1 advanced to log sequence 19 (LGWR switch)
　　Current log# 1 seq# 19 mem# 0: /u01/app/oracle/oradata/dg/redo01.log
　　Mon Apr 30 11:59:21 2012
　　Stopping background process CJQ0
　　Stopping background process QMNC
　　Mon Apr 30 11:59:22 2012

　　Archived Log entry 26 added for thread 1 sequence 18>　　All dispatchers and shared servers shutdown
　　CLOSE: killing server sessions.
　　CLOSE: all sessions shutdown successfully.
　　Waiting for all non-current ORLs to be archived...
　　All non-current ORLs have been archived.
　　Waiting for all FAL entries to be archived...
　　All FAL entries have been archived.
　　Waiting for potential Physical Standby switchover target to become synchronized...

　　Active, synchronized Physical Standby switchover target has been>　　Switchover End-Of-Redo Log thread 1 sequence 19 has been fixed
　　Switchover: Primary highest seen SCN set to 0x0.0x10758d
　　ARCH: Noswitch archival of thread 1, sequence 19
　　ARCH: End-Of-Redo Branch archival of thread 1 sequence 19
　　ARCH: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
　　ARCH: Standby redo logfile selected for thread 1 sequence 19 for destination LOG_ARCHIVE_DEST_2

　　Archived Log entry 27 added for thread 1 sequence 19>　　ARCH: Archiving is disabled due to current logfile archival
　　Primary will check for some target standby to have received alls redo
　　Final check for a synchronized target standby. Check will be made once.
　　LOG_ARCHIVE_DEST_2 is a potential Physical Standby switchover target

　　Active, synchronized target has been>　　Target has also received all redo
　　Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/dg1/dg/trace/dg_ora_13575.trc

　　Clearing standby activation>　　The primary database controlfile was created using the
　　'MAXLOGFILES 16' clause.
　　There is space for up to 13 standby redo logfiles
　　Use the following SQL commands on the standby database to create
　　standby redo logfiles that match the primary database:

　　ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f'>
　　ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f'>
　　ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f'>
　　ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f'>　　Archivelog for thread 1 sequence 19 required for standby recovery
　　Switchover: Primary controlfile converted to standby controlfile succesfully.
　　Switchover: Complete - Database shutdown required

　　Completed:>　　Mon Apr 30 11:59:53 2012
　　Process (ospid 13546) is suspended due to switchover to physical standby operation.
　　Mon Apr 30 11:59:57 2012
　　Process (ospid 13581) is suspended due to switchover to physical standby operation