Skip to Content
avatar image
Former Member

How to recovery the standby database when there is huge gap of logs

Hello all,

We have oracle 10g Dataguard configured for DRSetup running with SAP 4.7 EE & Oracle 10.2.0.4.0

My DR SERVER went down for a longer time & appreantly no one has notice that...

Now i am trying to run a recovery of the same with following steps..

I have copied all the archive logs from primary to standby database & trying to run with the following commands

There are around 3600 logs needst obe applied

STARTUP NOMOUNT;

ALTER DATABASE MOUNT STANDBY DATABASE;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

But i dont see recovery is happpening. Please adivce how can i put both primary & standby in sync.

Thanks & Regards,

Rahul

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Jan 19, 2011 at 07:24 AM

    Hi Rahul,

    You can use the command....

    ALTER DATABASE REGISTER LOGFILE '/PATH/ARCHIVELOG_NAME';

    You can make a script to register 3600 log files at once.....

    Then execute the command...

    alter database recover managed standby database disconnect;

    Thank You,

    Salman Qayyum

    Edited by: Salman M.A. Qayyum on Jan 19, 2011 8:26 AM

    Edited by: Salman M.A. Qayyum on Jan 19, 2011 8:27 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 19, 2011 at 07:31 AM

    Hi,

    Just try with "RECOVER STANDBY DATABASE"

    Nirmal.K

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Check if it's easier to recreate the standby rather to roll up all those arch-files (if you have all)

      SELECT * FROM V$ARCHIVE_GAP; on primary gives you rows if there are a gap.

      ALTER DATABASE RECOVER MANAGED STANDBY DATABASE; on standby will tell you which arch-file it expects. Look in standby database alert<SID>.log file for the same information.

      Regards

      Audun

      DBA

  • avatar image
    Former Member
    Jan 20, 2011 at 09:24 AM
    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

    The command itself says you that recovery happens in background and disconnecting from dialog session.

    Just enter the above command and run select sequence#, applied, from v$archived_log;

    OR

    Check your alertSID.log for the current status.

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 20, 2011 at 02:28 PM

    This is one of the simplest way to do it.

    1. Check the SCN on standby

    SQL>select current_scn from v$database;

    CURRENT_SCN

    -


    47987632

    2. Take incremental SCN backup on Primary

    RMAN> BACKUP INCREMENTAL FROM SCN 47987632 DATABASE;

    3. Recover the database

    SQL>recover managed standby database cancel;

    RMAN> RECOVER DATABASE NOREDO;

    SQL> recover managed standby database nodelay disconnect;

    Rgds,

    JP.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 20, 2011 at 03:04 PM

    You may want to consider using (PIT) recover command until timestamp.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2011 at 04:21 AM

    Since the archive logs are not available.

    i took a fresh online backup & restored & tried to follow a standarad process log shipping but hit with a new issues posted in the following thread..

    ORA-19527: physical standby redo log must be renamed _ issue in standby DB

    thank you for the support

    rahul..

    Add comment
    10|10000 characters needed characters exceeded