switch-s2-DOT1-13082015.log

Thu Aug 13 20:05:19 2015
Starting switchover [Process ID: 16298]
Thu Aug 13 20:05:19 2015
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 16298] (DOT1)
Waiting for target standby to receive all redo
Thu Aug 13 20:05:19 2015
Waiting for all non-current ORLs to be archived...
Thu Aug 13 20:05:19 2015
All non-current ORLs have been archived.
Thu Aug 13 20:05:19 2015
Waiting for all FAL entries to be archived...
Thu Aug 13 20:05:19 2015
All FAL entries have been archived.
Thu Aug 13 20:05:19 2015
Waiting for dest_id 2 to become synchronized...
Thu Aug 13 20:05:22 2015
Active, synchronized Physical Standby switchover target has been identified
Preventing updates and queries at the Primary
Generating and shipping final logs to target standby
Switchover End-Of-Redo Log thread 1 sequence 16 has been fixed
Switchover End-Of-Redo Log thread 2 sequence 13 has been fixed
Switchover: Primary highest seen SCN set to 0x0.0x2522f3
ARCH: Noswitch archival of thread 1, sequence 16
ARCH: End-Of-Redo Branch archival of thread 1 sequence 16
ARCH: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_2 after log switch
ARCH: Standby redo logfile selected for thread 1 sequence 16 for destination LOG_ARCHIVE_DEST_2
ARCH: Noswitch archival of thread 2, sequence 13
ARCH: End-Of-Redo Branch archival of thread 2 sequence 13
ARCH: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_2 after log switch
ARCH: Standby redo logfile selected for thread 2 sequence 13 for destination LOG_ARCHIVE_DEST_2
Thu Aug 13 20:05:34 2015
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/base/diag/rdbms/dot/DOT1/trace/DOT1_ora_16298.trc
Converting the primary database to a new standby database
Clearing standby activation ID 522968176 (0x1f2bdc70)
The primary database controlfile was created using the
'MAXLOGFILES 192' clause.
There is space for up to 188 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;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 52428800;
Archivelog for thread 1 sequence 16 required for standby recovery
Archivelog for thread 2 sequence 13 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Thu Aug 13 20:05:38 2015
Reconfiguration started (old inc 4, new inc 6)
List of instances (total 1) :
 1
Dead instances (total 1) :
 2
My inst 1
publish big name space -  dead or down/up instance detected, invalidate domain 0
 Global Resource Directory frozen
 * dead instance detected - domain 0 invalid = TRUE
 Communication channels reestablished
 Master broadcasted resource hash value bitmaps
 Non-local Process blocks cleaned out
Thu Aug 13 20:05:38 2015
 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 Set master node info
 Submitted all remote-enqueue requests
 Dwn-cvts replayed, VALBLKs dubious
 All grantable enqueues granted
Thu Aug 13 20:05:38 2015
 Post SMON to start 1st pass IR
Thu Aug 13 20:05:38 2015
Instance recovery: looking for dead threads
Process (ospid 4814) is suspended due to switchover to physical standby operation.
Thu Aug 13 20:05:38 2015
Switchover: Complete - Database shutdown required
Sending request(convert to primary database) to switchover target DTF
Thu Aug 13 20:05:38 2015
 Submitted all GCS remote-cache requests
 Fix write in gcs resources
Thu Aug 13 20:05:38 2015
Reconfiguration complete (total time 0.1 secs)
Thu Aug 13 20:05:39 2015
Process (ospid 4812) is suspended due to switchover to physical standby operation.
Thu Aug 13 20:05:44 2015
Switchover complete. Database shutdown required
USER (ospid: 16298): terminating the instance
Thu Aug 13 20:05:46 2015
Instance terminated by USER, pid = 16298
Completed: alter database switchover to dtf
Advertisements

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: