How do you setup a Physical stanby for Oracle 9i in Linux ?

ds_singh29
Profile Answers by ds_singh29 Questions by ds_singh29
Apr 18th, 2007
6
4394

Showing Answers 1 - 6 of 6 Answers

naveen5555
Profile Answers by naveen5555

Sep 21st, 2007

Creating a physical standby using RMAN

matabrez
Profile Answers by matabrez

Jan 9th, 2011

Steps for Physical standby for Oracle 9i in LINUX.

On Primary
Side
1. Take rman fullbackup with controlfile and spfile.
2. Take standby controlfile backup as SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/disk1/oracle/oradata/payroll/standby/payroll2.ctl';3.
3. CREATE PFILE='/disk1/oracle/dbs/initpayroll2.ora' FROM SPFILE;

On StandBy Side
1. Restore database using rman by using pfile from primary database.
2. Start the Physical Standby Database.
3. Initiate Log Apply Services
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
4.Verifying the Physical Standby Database
SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
5. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
6.
Check logs of both the database both should be sync.