Results 1 to 6 of 6

Thread: DataGuard Error

  1. #1
    Join Date
    Oct 2003
    Posts
    5

    Unanswered: DataGuard Error

    Hello
    I am trying to use datguard to mmake a standby database for my oracle 9i.When i am trying to open the standby database in the read only mode then i get the following error.

    SQL> ALTER DATABASE RECOVER MANAGED STANDBY

    DATABASE CANCEL;
    ALTER DATABASE RECOVER MANAGED STANDBY

    DATABASE CANCEL
    *
    ERROR at line 1:
    ORA-16136: Managed Standby Recovery not

    active

    Does anyone know the reason for this...
    Thanks
    Priya

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Hi,

    Are you sure it was in managed recovery mode?

    Check by:

    select max(sequence#) from v$log_history;

    on both databases to see if they are / were in sync.

    Rgs,
    Breen.

  3. #3
    Join Date
    Oct 2003
    Posts
    5
    Yes...
    none of the steps gave error.... and both the primary and secondary give the value as 1.... is it ok

  4. #4
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Hi,

    Found this:

    SQL> RECOVER MANAGED STANDBY DATABASE cancel;
    ORA-16136: Managed Standby Recovery not active

    SQL> RECOVER MANAGED STANDBY DATABASE disconnect from session;
    Media recovery complete.
    SQL>

    Try it.

    ----------------------

    If not My sequence is:

    SQL> startup nomount pfile=initSTBY.ora

    SQL> alter database mount standby database;

    SQL> alter database recover managed standby database disconnect;

    ---------------------

    Let me know,
    Breen.

  5. #5
    Join Date
    Oct 2003
    Posts
    5
    I have done all the three commands told by you and none of them gave error.... it even said media recovery complete......
    After the steps i assumed that its done and tried openeing in read only mode to check out if things are really being backued up.... but i got the error

  6. #6
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Hi Priya,

    I just want to confirm that you are cancelling recovery before you try to open it read only?

    SQL> alter database recover managed standby database cancel;

    SQL> alter database open read only;

    Another thing:

    When in recovery mode have you switched the logfile to confirm that it is indeed replicating the data accross to standby:

    SQL> alter system switch logfile;

    Rgs,
    Breen.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •