How to move Standby Database to a new server

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    How to move Standby Database to a new server

1. Prepare the new host with fresh rdbms installation same operating system and database patch level

Make sure you handle and files outside ORACLE_HOME (/var/opt/oracle/oratab)

2. Make sure you create necessary directory structure and the listener.ora & tnsnames.ora

( Listener.ora should have the new servername and IP address.)

3. Defer the redo transport from primary

alter system set log_archive_dest_state=defer scope=both sid='*';

4. Shutdown the standby

alter database recover managed standby database cancel;
shu immediate

5. Copy standby database files (data,ctrl,online log,spfile) to new host

6. Make sure we able to connect to new host using tns alias from the primary after modifying the prod tnsnames to reflect the new configuration

7. Bring up the standby
startup mount
alter database recover managed standby database disconnect;

8. Resume redo transport from primary

alter system set log_archive_dest_state=enable scope=both sid='*';

Get Oracle Certifications for all Exams
Free Online Exams.com