Primary Database:
Step1: Transfer all the archive log files
[oracle@dbvisit1 standby]$ ./dbvisit proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.9151) (pid 11969)
dbvisit started on dbvisit1: Fri May 2 12:02:55 2014 ()
=============================================================
Obtaining information from standby database (RUN_INSPECT=Y)...
Checking Dbvisit Standby configurational differences between dbvisit1 and dbvisit2...
No Dbvisit Standby configurational differences found between dbvisit1 and dbvisit2.
Log file(s) for proda will be transferred from dbvisit1 to dbvisit2...
Transferring o1_mf_1_30_9p6gcgcx_.arc.gz to host dbvisit2:o1_mf_1_30_9p6gcgcx_.arc.gz
Transferring o1_mf_1_31_9p6ghhks_.arc.gz to host dbvisit2:o1_mf_1_31_9p6ghhks_.arc.gz
201405021202 - 2 Log transfers to dbvisit2 for proda completed.
Last sequence was 31.
Dbvisit Archive Management Module (AMM)
(Number to keep: 0) (Days to keep: 7) (Archive backup count: 0) (Diskspace full threshold: 80%)
Current Disk percent full (/u01/app/oracle/fast_recovery_area) : 32%
=============================================================
dbvisit ended on dbvisit1: Fri May 2 12:03:08 2014
=============================================================
Step2: Starting switchover from Primary Database
[oracle@dbvisit1 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 12348)
dbv_oraStartStop started on dbvisit1: Fri May 2 12:04:51 2014 ()
=============================================================
=============================================================
Graceful Switchover starting on Primary Database proda with standby database proda.
Timestamp: 201405021204.
>>> Database proda will be shutdown and restarted <<<
Ensure Dbvisit is no longer scheduled.
>>> Gracefull Switchover will attempt to reset Oracle parameters db_file_name_convert and log_file_name_convert to default values (null strings) in the spfile <<<
Obtaining archive log gap....
Contacting Standby Database proda on dbvisit2...
Last standby sequence obtained (31) for thread 1.
Archive Log Gap for thread 1 is: 0. This is correct to continue.
Please enter unique key to begin graceful switchover for database proda.
The same key must be entered on both primary and standby server.
Please start command: dbv_oraStartStop switchover proda
on dbvisit2 if not already started.
Please enter unique key:
switch
Key switch entered.
Contacting dbvisit2 to ensure the same unique key is entered for proda.
Waiting for Key 1 on dbvisit2...
switchCheckpoint 1 completed. Key found on dbvisit2
Transferring X.dbvisit.switch.proda.tempfile to host dbvisit2:X.dbvisit.switch.p
Transferring X.dbvisit.switch.proda.force_logging to host dbvisit2:X.dbvisit.swi
Waiting for Checkpoint 2 on dbvisit2...
Checkpoint 2 completed. Key found on dbvisit2
Waiting for Checkpoint 3 on dbvisit2...
Checkpoint 3 completed. Key found on dbvisit2
Shutting down regular Database proda...
Regular Database proda shutdown successfully.
Starting Regular Database proda...
Regular Database proda started restrict.
Performing Oracle Checkpoint.
Waiting 3 seconds for log switch completion...
Creating standby controlfile controlfile...
Waiting for Checkpoint 4 on dbvisit2...
Checkpoint 4 completed. Key found on dbvisit2
Copying new archives for proda to dbvisit2...
Compressing o1_mf_1_32_9p6h5ssl_.arc...
Transferring o1_mf_1_32_9p6h5ssl_.arc.gz to host dbvisit2:o1_mf_1_32_9p6h5ssl_.arc.gz
Compressing o1_mf_1_33_9p6h747n_.arc...
Transferring o1_mf_1_33_9p6h747n_.arc.gz to host dbvisit2:o1_mf_1_33_9p6h747n_.arc.gz
Transferring X.dbvisit.switch.proda.archives to host dbvisit2:X.dbvisit.switch.proda.archives
Completed.
Shutting down regular Database proda...
Regular Database proda shutdown successfully.
Copying redo logs ... this may take a while...
Compressing X.dbvisit.switch.proda.redo_1.log...
Transferring X.dbvisit.switch.proda.redo_1.log.gz to host dbvisit2:X.dbvisit.switch.proda.redo_1.log.gz
Compressing X.dbvisit.switch.proda.redo_2.log...
Transferring X.dbvisit.switch.proda.redo_2.log.gz to host dbvisit2:X.dbvisit.switch.proda.redo_2.log.gz
Compressing X.dbvisit.switch.proda.redo_3.log...
Transferring X.dbvisit.switch.proda.redo_3.log.gz to host dbvisit2:X.dbvisit.switch.proda.redo_3.log.gz
Transferring X.dbvisit.switch.proda.redo_matrix to host dbvisit2:X.dbvisit.switch.proda.redo_matrix
Waiting for Checkpoint 5 on dbvisit2...
Checkpoint 5 completed. Key found on dbvisit2
Backing up current controlfiles for proda dbvisit1...
Database proda on dbvisit1 is already down. No action taken.
Starting Regular Database proda...
Regular Database proda started nomount.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Controlfile backed up as /usr/tmp/GS/proda/X.dbvisit.switch.proda.controlfile.
Database proda on dbvisit1 is already down. No action taken.
Transferring X.dbvisit.switch.proda.controlfile to host dbvisit2:X.dbvisit.switch.proda.controlfile
Waiting for Checkpoint 6 on dbvisit2...
Checkpoint 6 completed. Key found on dbvisit2
Waiting for Checkpoint 7 on dbvisit2...
Checkpoint 7 completed. Key found on dbvisit2
Waiting for Checkpoint 8 on dbvisit2...
Checkpoint 8 completed. Key found on dbvisit2
Waiting for Checkpoint 9 on dbvisit2...
Checkpoint 9 completed. Key found on dbvisit2
Waiting for Checkpoint 10 on dbvisit2...
Checkpoint 10 completed. Key found on dbvisit2
Waiting for Checkpoint 11 on dbvisit2...
Checkpoint 11 completed. Key found on dbvisit2
Waiting for Checkpoint 12 on dbvisit2...
Checkpoint 12 completed. Key found on dbvisit2
Database proda on dbvisit1 is already down. No action taken.
Starting Regular Database proda...
Regular Database proda started nomount.
STANDBY controlfile created.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Starting Standby Database proda...
Standby Database proda started .
Waiting for Checkpoint 13 on dbvisit2...
Checkpoint 13 completed. Key found on dbvisit2
Waiting for Checkpoint 14 on dbvisit2...
Checkpoint 14 completed. Key found on dbvisit2
File dbv_proda.env copied to dbv_proda.env.201405021204.
Dbvisit Database configuration (DDC) file dbv_proda.env has been updated and variables have been reversed between primary and standby server.
SOURCE=dbvisit2 DESTINATION=dbvisit1.
Waiting for Checkpoint 15 on dbvisit2...
Checkpoint 15 completed. Key found on dbvisit2
Waiting for Checkpoint 16 on dbvisit2...
Checkpoint 16 completed. Key found on dbvisit2
Waiting for Checkpoint 17 on dbvisit2...
Checkpoint 17 completed. Key found on dbvisit2
Tempfiles dropped.
Waiting for Checkpoint 18 on dbvisit2...
201405021204 - Cancelling graceful switchover, because processing has stopped on dbvisit2
Status: Database proda has been converted to standby database.
No further roll forward action required on dbvisit1.
Dbvisit Standby terminated.
Return code = 960
(Tracefile required if contacting Dbvisit Standby support: /usr/tmp/12348_dbv_oraStartStop_switchover_proda_201405021204.trc (server:dbvisit1))
You have new mail in /var/spool/mail/oracle
[oracle@dbvisit1 standby]$
Step3: Synchronization on Physical Standby Database
[oracle@dbvisit2 standby]$ ./dbvisit proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.9151) (pid 9636)
dbvisit started on dbvisit2: Fri May 2 12:03:17 2014 ()
=============================================================
Log file(s) for proda from dbvisit1 will be applied to dbvisit2...
201405021203 - Log seq 23 thread 1 applied to standby database proda.
201405021203 - Log seq 24 thread 1 applied to standby database proda.
201405021203 - Log seq 25 thread 1 applied to standby database proda.
201405021203 - Log seq 26 thread 1 applied to standby database proda.
201405021203 - Log seq 27 thread 1 applied to standby database proda.
201405021203 - Log seq 28 thread 1 applied to standby database proda.
201405021203 - Log seq 29 thread 1 applied to standby database proda.
201405021203 - Log seq 30 thread 1 applied to standby database proda.
201405021203 - Log seq 31 thread 1 applied to standby database proda.
Dbvisit Archive Management Module (AMM)
(Number to keep: 0) (Days to keep: 7) (Diskspace full threshold: 80%)
Processing /oracle/oraarch/proda...
Archive log dir: /oracle/oraarch/proda
Total number of archive files : 28
Number of files deleted : 0
Current Disk percent full : 31%
=============================================================
dbvisit ended on dbvisit2: Fri May 2 12:04:31 2014
=============================================================
Step4: Converting Physical Standby Database to Primary Database
[oracle@dbvisit2 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 10084)
dbv_oraStartStop started on dbvisit2: Fri May 2 12:04:38 2014 ()
=============================================================
=============================================================
Graceful Switchover starting on Standby Database proda.
Timestamp: 201405021204.
Database proda will be shutdown and restarted!
Ensure Dbvisit is no longer scheduled.
Please enter unique key to begin graceful switchover for database proda.
The same key must be entered on both primary and standby server.
Please start command: dbv_oraStartStop switchover proda
on dbvisit1 if not already started.
Please enter unique key:
switch
Key switch entered.
Contacting dbvisit1 to ensure the same unique key is entered for proda.
Waiting for Key 1 on dbvisit1...
Checkpoint 1 completed. Key found on dbvisit1
Waiting for Checkpoint 2 on dbvisit1...
Checkpoint 2 completed. Key found on dbvisit1
Waiting for Checkpoint 3 on dbvisit1...
Checkpoint 3 completed. Key found on dbvisit1
Waiting for Checkpoint 4 on dbvisit1...
Checkpoint 4 completed. Key found on dbvisit1
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Waiting for Checkpoint 5 on dbvisit1...
Checkpoint 5 completed. Key found on dbvisit1
Uncompressing o1_mf_1_32_9p6h5ssl_.arc.gz...
Uncompressing o1_mf_1_33_9p6h747n_.arc.gz...
Uncompressing X.dbvisit.switch.proda.redo_1.log.gz...
Uncompressing X.dbvisit.switch.proda.redo_2.log.gz...
Uncompressing X.dbvisit.switch.proda.redo_3.log.gz...
Waiting for Checkpoint 6 on dbvisit1...
Checkpoint 6 completed. Key found on dbvisit1
Waiting for Checkpoint 7 on dbvisit1...
Checkpoint 7 completed. Key found on dbvisit1
Backing up current controlfiles for proda dbvisit2...
Database proda on dbvisit2 is already down. No action taken.
Starting Standby Database proda...
Standby Database proda started nomount.
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Controlfile backed up as /usr/tmp/GS/proda/X.dbvisit.switch.proda.stdby_ctl_bck.
Database proda on dbvisit2 is already down. No action taken.
Waiting for Checkpoint 8 on dbvisit1...
Checkpoint 8 completed. Key found on dbvisit1
Starting Standby Database proda...
Standby Database proda started nomount.
Database proda on dbvisit2 is already started. No action taken.
PRIMARY controlfile created.
Mount Database proda...
Database proda mounted.
Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_1.log
File /u01/app/oracle/fast_recovery_area/PRODA/onlinelog/o1_mf_1_9p3q3gs3_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_1.log.
Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_2.log
File /u01/app/oracle/oradata/PRODA/onlinelog/o1_mf_1_9p3q3d9m_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_2.log.
Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_1.log
File /u01/app/oracle/fast_recovery_area/PRODA/onlinelog/o1_mf_2_9p3q3ljx_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_1.log.
Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_2.log
File /u01/app/oracle/oradata/PRODA/onlinelog/o1_mf_2_9p3q3l6o_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_2.log.
Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_3.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_1.log
File /u01/app/oracle/fast_recovery_area/PRODA/onlinelog/o1_mf_3_9p3q3t8n_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_1.log.
Copying redo log /usr/tmp/GS/proda/X.dbvisit.switch.proda.redo_3.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_2.log
File /u01/app/oracle/oradata/PRODA/onlinelog/o1_mf_3_9p3q3qvn_.log renamed to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_2.log.
Waiting for Checkpoint 9 on dbvisit1...
Checkpoint 9 completed. Key found on dbvisit1
Recovering new primary database...
Completed.
Waiting for Checkpoint 10 on dbvisit1...
Checkpoint 10 completed. Key found on dbvisit1
Archive log all for Database proda...
Completed.
Tempfiles dropped.
Waiting for Checkpoint 11 on dbvisit1...
Checkpoint 11 completed. Key found on dbvisit1
Open Database proda...
Database proda opened.
Waiting for Checkpoint 12 on dbvisit1...
Checkpoint 12 completed. Key found on dbvisit1
Waiting for Checkpoint 13 on dbvisit1...
Checkpoint 13 completed. Key found on dbvisit1
Waiting for Checkpoint 14 on dbvisit1...
Checkpoint 14 completed. Key found on dbvisit1
File dbv_proda.env copied to dbv_proda.env.201405021204.
Dbvisit Database configuration (DDC) file dbv_proda.env has been updated and variables have been reversed between primary and standby server.
SOURCE=dbvisit2 DESTINATION=dbvisit1.
Waiting for Checkpoint 15 on dbvisit1...
Checkpoint 15 completed. Key found on dbvisit1
Tempfiles created.
Waiting for Checkpoint 16 on dbvisit1...
Checkpoint 16 completed. Key found on dbvisit1
Compressing o1_mf_1_32_9p6h5ssl_.arc...
Compressing o1_mf_1_33_9p6h747n_.arc...
Waiting for Checkpoint 17 on dbvisit1...
Checkpoint 17 completed. Key found on dbvisit1
201405021204 - Problem with obtaining the last sequence from standby database on dbvisit1.
201405021210 - Directory ARCHDEST "/oracle/oraarch/proda" does not exists and cannot be created. Please check permissions or create directory on dbvisit1. Dbvisit
Standby terminated.Return code = 853(Tracefile required if contacting Dbvisit Standby support: /usr/tmp/17418_dbv_functions_proda_201405021210.trc (server:dbvisit1))
Please check Standby Database is up and runnning on dbvisit2, else please contact Dbvisit support.
Status: Database proda has been converted to the Primary Database.
No further roll forward action required on dbvisit2.
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover.
To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = '/u01/app/oracle/fast_recovery_area' scope=both;
Dbvisit Standby terminated.
Return code = 85
(Tracefile required if contacting Dbvisit Standby support: /usr/tmp/10084_dbv_oraStartStop_switchover_proda_201405021204.trc (server:dbvisit2))
[oracle@dbvisit2 standby]$
No comments:
Post a Comment