DR server in stanby mode

[Former Member]

Hi,

We have one DR server. And we want to test the DR server.

Log shipment happens manually its not automatic.

Sys info.

OS : HP UX

Oracle 9.0.2.6

archive logs applied till 03-05-2010.

copied all the files from primary servers ( /oracle/P11/920_64/dbs ) to DR server.

When i try to mount database in DR server it throws an error. "ORA-01666: controlfile is for a standby database".

I dont know how to make the DR server database from standby to online.How to make it operational....

Regards,

Viren.

[Former Member]

Hello,

Stop the log import script.Ensure the log import script has finished importing all the currently available redo logs in saparch.

Activate the DR DB by the following comand.

SQL> alter database activate standby database;

After that you have to create the PSAPTEMP files manually.

Thanks,

Nick S

[Former Member]

Hi,

Do the procudure to test stand by server.

1. Copy the lastest backup files (.ant) from primary server to DR server in the following location /oracle home/sapbackup

execute the below said commands in ora(sid> user

>brrestore u2013b <ur ant file name> u2013m full.

2. then copy all the saprach files from primary server to DR server in the following location /oracle/<sid>/saparch.

>brrestore u2013a Startfilenumber-Endfile

Recovery the Database

========================

1. Connect to the database with sys as sysdba

2. Start the database with mount option

SQL> startup mount

3. Apply the Archive file

SQL> Recover database until cancel using backup controlfile;

Note : If archive file not in sequence press the Enter up to end of the file.

If archive file in sequence manner give the command Auto

4. Opening the Database

SQL>Alter database open resetlogs;

Database altered & opened .Start the SAP Restoration completed.

I hope it help to us.

Regards

Senthil