switch.s2.primary.25112014_log

alter database switchover to cdb1
Tue Nov 25 21:41:07 2014
Starting switchover [Process ID: 7676]
Tue Nov 25 21:41:07 2014
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 7676] (cdb0)
Waiting for target standby to receive all redo
Tue Nov 25 21:41:07 2014
Waiting for all non-current ORLs to be archived...
Tue Nov 25 21:41:07 2014
All non-current ORLs have been archived.
Tue Nov 25 21:41:07 2014
Waiting for all FAL entries to be archived...
Tue Nov 25 21:41:07 2014
All FAL entries have been archived.
Tue Nov 25 21:41:07 2014
Waiting for dest_id 2 to become synchronized...
Tue Nov 25 21:41:08 2014
Active, synchronized Physical Standby switchover target has been identified
Preventing updates and queries at the Primary
Tue Nov 25 21:41:08 2014
Process (ospid 4609) is suspended due to switchover to physical standby operation.
Tue Nov 25 21:41:09 2014
Generating and shipping final logs to target standby
Switchover End-Of-Redo Log thread 1 sequence 36 has been fixed
Switchover: Primary highest seen SCN set to 0x0.0x24e485
ARCH: Noswitch archival of thread 1, sequence 36
ARCH: End-Of-Redo Branch archival of thread 1 sequence 36
ARCH: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_2 after log switch
ARCH: Standby redo logfile selected for thread 1 sequence 36 for destination LOG_ARCHIVE_DEST_2
ARCH: Archiving is disabled due to current logfile archival
Primary will check for some target standby to have received all redo
Waiting for target standby to apply all redo
Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/cdb0/cdb0/trace/cdb0_ora_7676.trc
Converting the primary database to a new standby database
Clearing standby activation ID 1981095743 (0x76151f3f)
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' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;
Archivelog for thread 1 sequence 36 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Switchover: Complete - Database shutdown required
Sending request(convert to primary database) to switchover target CDB1
Switchover complete. Database shutdown required
USER (ospid: 7676): terminating the instance
Tue Nov 25 21:41:16 2014
Instance terminated by USER, pid = 7676
Completed: alter database switchover to cdb1
Shutting down instance (abort)
License high water mark = 7
Tue Nov 25 21:41:16 2014
Instance shutdown complete

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: