nafees

 Profile Answers by nafees 

• Jul 21st, 2008

 

Hi all,

IT IS POSSIBLE WITH THE HELP OF DATA GUARD.

To  create a physical standby database ,the standby databse should be in MRM(Managed recovery mode)

Let  we proceed with an example, let  db10 is a production database server and db15 is a standby database server.

Steps to follow:

Db10:check whether the database is in archive log mode r not, if not make into archive log mode.

 Db10:Check whether the password file is existing r not,if not create a password file under

$ORACLE_HOME/dbs

Db10: configure a listener which refers the port no of db15

Db15: configure a tns with the same port no and sid which refers to listener at db10

Db15:configure a listener which refers to Tns of primary database i.e.db10,export the SID of production database, because in future it can act as a production database.

Db10:configure a Tns which refers the same port no of standby server’s listener

Db10:make a directory where we can copy all C/R/D files including password file and even parameter file by specifying dataguard related parameters.

Db10: startup the database in mount stage and create a standby control file in the same location where all the above files r copied.

Db15:create a directory to store all the data which transfers from production database.

Db10:using file transfer protocol(FTP) send the directory to db15

Db15: open the database in nomount stage by specifying valid dataguard parameters in db15 parameter file

Note:   the db10 (production database server) should be up  and running

Db15:alter the database to mount stage by specifying the standby database

Db15: keep the standby database in MRM(managed recovery mode).