Tuesday, May 27, 2014

Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)"


Article No 21 : Published Oracle Technical Article in World Famous Site "Oracle Technology Network (OTN)"

Article Title : Oracle Exadata Database Machine: "Exachk"

Article URL : http://www.oracle.com/technetwork/pt/articles/servers-storage-admin/oracle-exadata-exachk-2209072-ptb.html


Saturday, May 17, 2014

Speaker @AIOUG (All India Oracle User Group) - Oracle ExaDataSIG’s first Webcast on May 28th 2014

Speaker @AIOUG Oracle ES SIG’s first Webcast on May 28th 2014.
=====================================================

Agenda
======
3.45 PM – 4 PM – Introduction to Oracle ES SIG

4 PM – 5 PM IST– Oracle Engineered Systems Overview & Introduction to Oracle Database Appliance (ODA).

5 PM – 6 PM IST– Oracle Exadata Database Machine Evolution by Y.V Ravi Kumar

Oracle ES SIG » Register oracle-es-sig.org

Wednesday, May 7, 2014

SwitchOver and SwitchBack Operations In Oracle Database (SE) using 'dbvisit' Software


SwitchOver Operation:

[oracle@dbvisit2 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 13892)
dbv_oraStartStop started on dbvisit2: Wed May  7 12:45:44 2014 ()
=============================================================
=============================================================
Graceful Switchover starting on Primary Database proda with standby database proda.
Timestamp: 201405071245.

>>> 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 dbvisit1...
Last standby sequence obtained (45) 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 dbvisit1 if not already started.

Please enter unique key:
back
Key back 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
Transferring X.dbvisit.back.proda.tempfile to host
dbvisit1:X.dbvisit.back.proda.tempfile
Transferring X.dbvisit.back.proda.force_logging to host
dbvisit1:X.dbvisit.back.proda.force_logging
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
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 dbvisit1...
Checkpoint 4 completed. Key found on dbvisit1
Copying new archives for proda to dbvisit1...
Compressing  arch1_46_846414148.dbf...
Transferring arch1_46_846414148.dbf.gz to host
dbvisit1:arch1_46_846414148.dbf.gz
Compressing  arch1_47_846414148.dbf...
Transferring arch1_47_846414148.dbf.gz to host
dbvisit1:arch1_47_846414148.dbf.gz
Transferring X.dbvisit.back.proda.archives to host
dbvisit1:X.dbvisit.back.proda.archives
Completed.
Shutting down regular Database proda...
Regular Database proda shutdown successfully.
Copying redo logs ... this may take a while...
Compressing  X.dbvisit.back.proda.redo_1.log...
Transferring X.dbvisit.back.proda.redo_1.log.gz to host
dbvisit1:X.dbvisit.back.proda.redo_1.log.gz
Compressing  X.dbvisit.back.proda.redo_2.log...
Transferring X.dbvisit.back.proda.redo_2.log.gz to host
dbvisit1:X.dbvisit.back.proda.redo_2.log.gz
Compressing  X.dbvisit.back.proda.redo_3.log...
Transferring X.dbvisit.back.proda.redo_3.log.gz to host
dbvisit1:X.dbvisit.back.proda.redo_3.log.gz
Transferring X.dbvisit.back.proda.redo_matrix to host
dbvisit1:X.dbvisit.back.proda.redo_matrix
Waiting for Checkpoint 5 on dbvisit1...
Checkpoint 5 completed. Key found on dbvisit1
Backing up current controlfiles for proda dbvisit2...
Database proda on dbvisit2 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.back.proda.controlfile.
Database proda on dbvisit2 is already down. No action taken.
Transferring X.dbvisit.back.proda.controlfile to host
dbvisit1:X.dbvisit.back.proda.controlfile
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
Waiting for Checkpoint 8 on dbvisit1...
Checkpoint 8 completed. Key found on dbvisit1
Waiting for Checkpoint 9 on dbvisit1...
Checkpoint 9 completed. Key found on dbvisit1
Waiting for Checkpoint 10 on dbvisit1...
Checkpoint 10 completed. Key found on dbvisit1
Waiting for Checkpoint 11 on dbvisit1...
Checkpoint 11 completed. Key found on dbvisit1
Waiting for Checkpoint 12 on dbvisit1...
Checkpoint 12 completed. Key found on dbvisit1
Database proda on dbvisit2 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 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.201405071245.
Dbvisit Database configuration (DDC) file dbv_proda.env has been updated and
variables have been reversed between primary and standby server.

SOURCE=dbvisit1 DESTINATION=dbvisit2.

Waiting for Checkpoint 15 on dbvisit1...
Checkpoint 15 completed. Key found on dbvisit1
Waiting for Checkpoint 16 on dbvisit1...
Checkpoint 16 completed. Key found on dbvisit1
Waiting for Checkpoint 17 on dbvisit1...
Checkpoint 17 completed. Key found on dbvisit1
Tempfiles dropped.
Waiting for Checkpoint 18 on dbvisit1...
Checkpoint 18 completed. Key found on dbvisit1

Graceful switchover completed.

This database (proda) is now a standby database.

To keep this new standby database in synch,
reschedule Dbvisit as per normal:
        dbvisit proda
=============================================================
dbv_oraStartStop ended on dbvisit2: Wed May  7 12:51:49 2014
=============================================================

[oracle@dbvisit2 standby]$

[oracle@dbvisit1 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 13791)
dbv_oraStartStop started on dbvisit1: Wed May  7 12:45:58 2014 ()
=============================================================

=============================================================
Graceful Switchover starting on Standby Database proda.
Timestamp: 201405071245.
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 dbvisit2 if not already started.

Please enter unique key:
back
Key back entered.

Contacting dbvisit2 to ensure the same unique key is entered for proda.
Waiting for Key 1 on dbvisit2...
Checkpoint 1 completed. Key found on dbvisit2
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
Waiting for Checkpoint 4 on dbvisit2...
Checkpoint 4 completed. Key found on dbvisit2
Shutting down standby Database proda...
Standby Database proda shutdown successfully.
Waiting for Checkpoint 5 on dbvisit2...
Checkpoint 5 completed. Key found on dbvisit2
Uncompressing arch1_46_846414148.dbf.gz...
Uncompressing arch1_47_846414148.dbf.gz...
Uncompressing X.dbvisit.back.proda.redo_1.log.gz...
Uncompressing X.dbvisit.back.proda.redo_2.log.gz...
Uncompressing X.dbvisit.back.proda.redo_3.log.gz...
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
Backing up current controlfiles for proda dbvisit1...
Database proda on dbvisit1 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.back.proda.stdby_ctl_bck.
Database proda on dbvisit1 is already down. No action taken.
Waiting for Checkpoint 8 on dbvisit2...
Checkpoint 8 completed. Key found on dbvisit2
Starting Standby Database proda...
Standby Database proda started nomount.
Database proda on dbvisit1 is already started. No action taken.
PRIMARY controlfile created.
Mount Database proda...
Database proda mounted.
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_2.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_2.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_3.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.back.proda.redo_3.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_2.log
Waiting for Checkpoint 9 on dbvisit2...
Checkpoint 9 completed. Key found on dbvisit2
Recovering new primary database...
Completed.
Waiting for Checkpoint 10 on dbvisit2...
Checkpoint 10 completed. Key found on dbvisit2
Archive log all for Database proda...
Completed.
Tempfiles dropped.
Waiting for Checkpoint 11 on dbvisit2...
Checkpoint 11 completed. Key found on dbvisit2
Open Database proda...
Database proda opened.
Waiting for Checkpoint 12 on dbvisit2...
Checkpoint 12 completed. Key found on dbvisit2
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.201405071245.
Dbvisit Database configuration (DDC) file dbv_proda.env has been updated and
variables have been reversed between primary and standby server.

SOURCE=dbvisit1 DESTINATION=dbvisit2.

Waiting for Checkpoint 15 on dbvisit2...
Checkpoint 15 completed. Key found on dbvisit2
Tempfiles created.
Waiting for Checkpoint 16 on dbvisit2...
Checkpoint 16 completed. Key found on dbvisit2
Compressing  arch1_46_846414148.dbf...
Compressing  arch1_47_846414148.dbf...
Waiting for Checkpoint 17 on dbvisit2...
Checkpoint 17 completed. Key found on dbvisit2

FORCE LOGGING is left turned off in the primary database proda on dbvisit1.
Waiting for Checkpoint 18 on dbvisit2...
Checkpoint 18 completed. Key found on dbvisit2

Graceful switchover completed.

This database (proda) is now the primary database.

You may consider re-creating a password file to make sure all sysdba passwords are preserved.
To keep the standby database on dbvisit2 in synch with this primary database,
reschedule Dbvisit as per normal:
        dbvisit proda
=============================================================
dbv_oraStartStop ended on dbvisit1: Wed May  7 12:51:50 2014
=============================================================

You have new mail in /var/spool/mail/oracle
[oracle@dbvisit1 standby]$

SwitchBack Operation:
[oracle@dbvisit1 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 21725)
dbv_oraStartStop started on dbvisit1: Wed May  7 13:23:59 2014 ()
=============================================================

=============================================================
Graceful Switchover starting on Primary Database proda with standby database
proda.
Timestamp: 201405071323.

>>> 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 (55) 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:
dbvisit
Key dbvisit entered.

Contacting dbvisit2 to ensure the same unique key is entered for proda.
Waiting for Key 1 on dbvisit2...
Checkpoint 1 completed. Key found on dbvisit2
Transferring X.dbvisit.dbvisit.proda.tempfile to host
dbvisit2:X.dbvisit.dbvisit.proda.tempfile
Transferring X.dbvisit.dbvisit.proda.force_logging to host
dbvisit2:X.dbvisit.dbvisit.proda.force_logging
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_56_9pmsq68o_.arc...
Transferring o1_mf_1_56_9pmsq68o_.arc.gz to host
dbvisit2:o1_mf_1_56_9pmsq68o_.arc.gz
Compressing  o1_mf_1_57_9pmsrlwo_.arc...
Transferring o1_mf_1_57_9pmsrlwo_.arc.gz to host
dbvisit2:o1_mf_1_57_9pmsrlwo_.arc.gz
Transferring X.dbvisit.dbvisit.proda.archives to host
dbvisit2:X.dbvisit.dbvisit.proda.archives
Completed.
Shutting down regular Database proda...
Regular Database proda shutdown successfully.
Copying redo logs ... this may take a while...
Compressing  X.dbvisit.dbvisit.proda.redo_1.log...
Transferring X.dbvisit.dbvisit.proda.redo_1.log.gz to host
dbvisit2:X.dbvisit.dbvisit.proda.redo_1.log.gz
Compressing  X.dbvisit.dbvisit.proda.redo_2.log...
Transferring X.dbvisit.dbvisit.proda.redo_2.log.gz to host
dbvisit2:X.dbvisit.dbvisit.proda.redo_2.log.gz
Compressing  X.dbvisit.dbvisit.proda.redo_3.log...
Transferring X.dbvisit.dbvisit.proda.redo_3.log.gz to host
dbvisit2:X.dbvisit.dbvisit.proda.redo_3.log.gz
Transferring X.dbvisit.dbvisit.proda.redo_matrix to host
dbvisit2:X.dbvisit.dbvisit.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.dbvisit.proda.controlfile.
Database proda on dbvisit1 is already down. No action taken.
Transferring X.dbvisit.dbvisit.proda.controlfile to host
dbvisit2:X.dbvisit.dbvisit.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.201405071323.
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...
Checkpoint 18 completed. Key found on dbvisit2

Graceful switchover completed.

This database (proda) is now a standby database.

To keep this new standby database in synch,
reschedule Dbvisit as per normal:
        dbvisit proda
=============================================================
dbv_oraStartStop ended on dbvisit1: Wed May  7 13:30:32 2014
=============================================================

You have new mail in /var/spool/mail/oracle
[oracle@dbvisit1 standby]$

[oracle@dbvisit2 standby]$ ./dbv_oraStartStop switchover proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 23049)
dbv_oraStartStop started on dbvisit2: Wed May  7 13:24:13 2014 ()
=============================================================

=============================================================
Graceful Switchover starting on Standby Database proda.
Timestamp: 201405071324.
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:
dbvisit
Key dbvisit 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_56_9pmsq68o_.arc.gz...
Uncompressing o1_mf_1_57_9pmsrlwo_.arc.gz...
Uncompressing X.dbvisit.dbvisit.proda.redo_1.log.gz...
Uncompressing X.dbvisit.dbvisit.proda.redo_2.log.gz...
Uncompressing X.dbvisit.dbvisit.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.dbvisit.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.dbvisit.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.redo_1.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_1_2.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.redo_2.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_2_2.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.redo_3.log to /u01/app/oracle/oradata/PRODA/onlinelog/redo_3_1.log
Copying redo log /usr/tmp/GS/proda/X.dbvisit.dbvisit.proda.redo_3.log 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.201405071324.
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_56_9pmsq68o_.arc...
Compressing  o1_mf_1_57_9pmsrlwo_.arc...
Waiting for Checkpoint 17 on dbvisit1...
Checkpoint 17 completed. Key found on dbvisit1

FORCE LOGGING is left turned off in the primary database proda on dbvisit2.
Waiting for Checkpoint 18 on dbvisit1...
Checkpoint 18 completed. Key found on dbvisit1

Graceful switchover completed.

This database (proda) is now the primary database.

You may consider re-creating a password file to make sure all sysdba passwords are preserved.
To keep the standby database on dbvisit1 in synch with this primary database,
reschedule Dbvisit as per normal:
        dbvisit proda
=============================================================
dbv_oraStartStop ended on dbvisit2: Wed May  7 13:30:27 2014
=============================================================

[oracle@dbvisit2 standby]$


Tuesday, May 6, 2014

Oracle Database (Standard Edition) - Disaster Recovery Testing Using 'dbvisit' Software


Primary Database:

[oracle@dbvisit1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Tue May 6 18:27:22 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> connect sys/oracle as sysdba
Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 1870647296 bytes
Fixed Size                  2229424 bytes
Variable Size             469764944 bytes
Database Buffers         1392508928 bytes
Redo Buffers                6144000 bytes
Database mounted.
Database opened.

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     11
Next log sequence to archive   13
Current log sequence           13

SQL> connect scott/oracle
Connected.

SQL> create table sample (no number);
Table created.

SQL> connect sys/oracle as sysdba
Connected.

SQL> alter system switch logfile;
System altered.

SQL> alter system switch logfile;
System altered.

Transferring Archive Log Files from Primary Database to Physical Standby Database:

[oracle@dbvisit1 standby]$ ./dbvisit proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.9151) (pid 4187)
dbvisit started on dbvisit1: Tue May  6 18:47:54 2014 ()
=============================================================

Obtaining information from standby database (RUN_INSPECT=Y)...
Checking Dbvisit Standby configurational differences between dbvisit1 and dbvisi                                                                                        t2...
No Dbvisit Standby configurational differences found between dbvisit1 and dbvisi                                                                                        t2.

Log file(s) for proda will be transferred from dbvisit1 to dbvisit2...
Transferring o1_mf_1_13_9pkr4coo_.arc.gz to host dbvisit2:o1_mf_1_13_9pkr4coo_.arc.gz
Transferring o1_mf_1_14_9pkr4n3j_.arc.gz to host  dbvisit2:o1_mf_1_14_9pkr4n3j_.arc.gz
Transferring o1_mf_1_15_9pkr4x53_.arc.gz to host dbvisit2:o1_mf_1_15_9pkr4x53_.arc.gz 
Transferring o1_mf_1_16_9pkr57jp_.arc.gz to host dbvisit2:o1_mf_1_16_9pkr57jp_.arc.gz
Transferring o1_mf_1_17_9pkr58hd_.arc.gz to host dbvisit2:o1_mf_1_17_9pkr58hd_.arc.gz
Transferring o1_mf_1_18_9pkr59fm_.arc.gz to host dbvisit2:o1_mf_1_18_9pkr59fm_.arc.gz
Transferring o1_mf_1_19_9pkr5b9y_.arc.gz to host dbvisit2:o1_mf_1_19_9pkr5b9y_.arc.gz
Transferring o1_mf_1_20_9pkr5c3c_.arc.gz to host dbvisit2:o1_mf_1_20_9pkr5c3c_.arc.gz
Transferring o1_mf_1_21_9pkr6ntl_.arc.gz to host dbvisit2:o1_mf_1_21_9pkr6ntl_.arc.gz
Transferring o1_mf_1_22_9pkr6oms_.arc.gz to host dbvisit2:o1_mf_1_22_9pkr6oms_.arc.gz
Transferring o1_mf_1_23_9pkr6sh4_.arc.gz to host dbvisit2:o1_mf_1_23_9pkr6sh4_.arc.gz
Transferring o1_mf_1_24_9pkr6shr_.arc.gz to host dbvisit2:o1_mf_1_24_9pkr6shr_.arc.gz
Transferring o1_mf_1_25_9pkr6xr7_.arc.gz to host dbvisit2:o1_mf_1_25_9pkr6xr7_.arc.gz
201405061847 - 13 Log transfers to dbvisit2 for proda completed.
         Last sequence was 25.
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: Tue May  6 18:48:26 2014
=============================================================
 
Physical Standby Database:

[oracle@dbvisit2 standby]$ ./dbvisit proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.9151) (pid 5293)
dbvisit started on dbvisit2: Tue May  6 18:53:29 2014 ()
=============================================================

Log file(s) for proda from dbvisit1 will be applied to dbvisit2...
201405061853 - Log seq 9 thread 1 applied to standby database proda.
201405061853 - Log seq 10 thread 1 applied to standby database proda.
201405061853 - Log seq 11 thread 1 applied to standby database proda.
201405061853 - Log seq 12 thread 1 applied to standby database proda.
201405061853 - Log seq 13 thread 1 applied to standby database proda.
201405061853 - Log seq 14 thread 1 applied to standby database proda.
201405061853 - Log seq 15 thread 1 applied to standby database proda.
201405061853 - Log seq 16 thread 1 applied to standby database proda.
201405061853 - Log seq 17 thread 1 applied to standby database proda.
201405061853 - Log seq 18 thread 1 applied to standby database proda.
201405061853 - Log seq 19 thread 1 applied to standby database proda.
201405061853 - Log seq 20 thread 1 applied to standby database proda.
201405061853 - Log seq 21 thread 1 applied to standby database proda.
201405061853 - Log seq 22 thread 1 applied to standby database proda.
201405061853 - Log seq 23 thread 1 applied to standby database proda.
201405061853 - Log seq 24 thread 1 applied to standby database proda.
201405061853 - Log seq 25 thread 1 applied to standby database proda.
201405061853 - Log seq 26 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   : 23
Number of files deleted         : 0
Current Disk percent full       : 31%

=============================================================
dbvisit ended on dbvisit2: Tue May  6 18:54:55 2014
=============================================================

You have new mail in /var/spool/mail/oracle
[oracle@dbvisit2 standby]$ ./dbv_oraStartStop open proda
=============================================================
Dbvisit Standby Database Technology (6.0.32.8890) (pid 6095)
dbv_oraStartStop started on dbvisit2: Tue May  6 18:55:14 2014 ()
=============================================================

Open Standby Database proda in READ ONLY mode...
Standby Database proda opened in READ ONLY mode.
Log files cannot be applied to Database while in READ ONLY mode.
Database tempfile(s) may need to be added to this database.

=============================================================
dbv_oraStartStop ended on dbvisit2: Tue May  6 18:55:22 2014
=============================================================

[oracle@dbvisit2 standby]$ exit
 
Check the Table in Physical Standby Database:

[oracle@dbvisit2 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Tue May 6 18:55:57 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> connect scott/oracle
Connected.

SQL> select * from sample;
no rows selected
 

Thursday, May 1, 2014

Oracle Database Switchover using 'dbvisit' for Oracle Database (Standard Edition)


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]$