DR Server problem

[Former Member]

Dear All,

We have SAP on Oracle 9i. There is also a DRServer on our remote site. I that i have restore whole database offline backup from my production server. Now i want to know that ..

1. where i can find the latest log of restore.

2. In that DR server, there is a error in starting teh SAP. It is not starting the databbase from startsap all cmd. But it is starting by sqlplus. In startsap all , it is giving error,

Trying to start PRD database ...

Log file: /home/prdadm/startdb.log

/usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 16

hat i have to do.

If there is any ther process to restore db, then tell me if i am wrong.

Regards,

Ankit

[Former Member · Accepted solution]

Ankit,

On your 2nd questions:

2. In that DR server, there is a error in starting teh SAP. It is not starting the databbase from startsap all cmd. But it is starting by sqlplus. In startsap all , it is giving error,

The database at DR is in recovery mode(mounted), it is not open for use. starting SAP will give you errors in DR. You can start SAP only when the failover is done and database is open for use.

Cheers,

Nisch

[Former Member · Accepted solution]

Hi Markus,

Yes, It is started from sqlplus, the log is.....

-

---

prdadm 29> sqlplus " / as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Aug 20 18:14:03 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 839600392 bytes

Fixed Size 727304 bytes

Variable Size 452984832 bytes

Database Buffers 384565248 bytes

Redo Buffers 1323008 bytes

Database mounted.

Database opened.

SQL>

-

---

Hi Nisch,

But my landscape is small so there is not online archiving of data from live server to drs server. So, i want to check that it is ok or not. so i want to check it from gui connectivty. Is there any procedure to check this?

Regards,

Ankit Gupta

[Former Member · Accepted solution]

Anikit,

To check the current status of the database, check alert log file and that will tell you if the database has any errors.

You need to understand the concepts of DR and do more reading on dataguard in SAP enviroment, you will find lots of resources if you google for it.

It is a good practice to maintain a document on the setup or refer to one when on a new enviroment to understand how it has been setup.

Hope this helps.

Cheers,

Nisch

[markus_doehr2 · Accepted solution]

The database opened - good! But:

Now you need to re-copy your source system again. Once the database has been "opened" you can´t recover any more the archive logs from your production.

Markus

[markus_doehr2 · Accepted solution]

> SQL*Plus: Release 9.2.0.4.0 - Production on Wed Aug 20 18:14:03 2008

ِAnd before I forget: Oracle 9.2.(0.4) is out of maintenance (check the top level article on ) - I highly suggest you upgrade to 10.2.

Markus

[Former Member · Accepted solution]

Hi markus,

i am highly thankfull to you to get my attention this side. could you tel me the general procedure to upgrade oracle rdbms.

Thanks in advance.

Regards,

Ankit

[markus_doehr2 · Accepted solution]

Check

http://service.sap.com/instguides

--> Other documentation

--> Database Upgrades

--> Oracle

Download the guide and follow it attentively.

Markus