Implement Oracle Datagurad Switchover-ylw6006
$ tail -f /u01/app/oracle/diag/rdbms/dg1/dg/trace/alert_dg.log Mon Apr 30 11:59:21 2012alter 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
页:
[1]