Skip to Content
avatar image
Former Member

DR Server problem

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 28, 2008 at 10:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 28, 2008 at 09:00 AM

    Is the DB mounting and openning properly via sqlplus?

    Whats the full error on startdb log? also can you do and R3trans -d and post the error on the trans.log?

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 28, 2008 at 09:04 AM

    check the output of "startdb.log"

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • The database your TNS is pointing to, is not started.

      Are you sure that the database could be correctly started using sqlplus?

      Please try:

      sqlplus / as sysdba
      shutdown abort
      startup

      What is the output?

      Markus