This discussion is archived
2 Replies Latest reply: Nov 30, 2013 4:50 AM by Fabricio_Jorge RSS

Configuring a physical standby database in 9i

Fabricio_Jorge Explorer
Currently Being Moderated

Hi all,


   SO: Solaris 10 SPARC x64

   DB: x64


   I have a task of creating a physical standby database in a solaris 10 - Oracle env. I am used to do this configuration on the 11.2 version of Oracle, and because of that i have some doubts regarding the possible different configurations necessary to do in a 9i Database.


   1) The main doubt that i have is regarding the RMAN use. I Would like to know if it is possible to restore a normal backup of my primary database into the standby database, and after that, apply the necessary archived logs to sync the standby with the primary? The controlfile that i would use would be the one created by the  "BACKUP CURRENT CONTROLFILE FOR STANDBY" RMAN command. The RMAN script woulb be like the one below:


run {


allocate channel ch01 device type disk;

allocate channel ch02 device type disk;

allocate channel ch03 device type disk;

allocate channel ch04 device type disk;


restore controlfile from 'standby_controlfile.ctl';


sql 'alter database mount';


restore database;

recover database;



   2) The directory structure will be the same, so i think it is not necessary to use the SET NEWNAME and the DB_FILE_NAME_CONVERT/LOG_FILE_NAME_CONVERT, is that correct?


   3) Do you have any other considerations regarting the differences between a 9i and a 11g Physical Standby Configuration?


Thanks for your attention and pacience.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points