Setting up DR Server

[Former Member]

Dear Sir,

Please send me steps for setting o DR Server for ECC 5 with oracle 9.2 database.

[Former Member]

Hi Ketan,

You can find the detailed information about DR configuration, in the document, below;

http://www.lorentzcenter.nl/awcourse/oracle/server.920/a96653.pdf

Best regards,

Orkun Gedik

[Former Member]

thanks for reply, Can u seen me steps with respect to sap.

[Former Member]

Hi Ketan,

I hope you might have gone through the document provided by Orkun Gedik. Here are the highlevel steps involved in setting up DR.

1. Install the SAP R/3 system in a similar hardware

2. Backup the PRD DB (offline backup)

3. Stop the application and DB in the DR site

4. Restore the backup in DR using BRRESTORE

5. Create a standby controlfile in PRD and copy the same to the controlfile locations in DR

6. Start the DB at the DR site in the standby mode

7. Copy the archive logs (you can either do this manually or automate the same usnig oracle dataguard)

8. Apply/recover the archive logs in the DR (ongoing process).

Hope this helps.

Regards,

Varadharajan M

[Former Member]

Hi Ketan,

I know only one document to setup a DR system on Oracle 11g for SAP customers;

http://www.oracle.com/us/solutions/sap/wp-ora4sap-dataguard11g-303811.pdf

As I noted that this document is not belong to 9i but you may follow the main steps on it and complement the steps with the previous document that I've noted you.

Best regards,

Orkun Gedik

[Former Member]

Hi Ketan,

Actually, the backup can also be an online backup. You would just need the archive logs generated during the backup as well to apply to the standby database.

Thanks,

Brian