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

[Former Member]

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

[Former Member]

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..

thank you for the support

rahul..

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[nirmal_konchada]

Hi,

Just try with "RECOVER STANDBY DATABASE"

Nirmal.K

[audunlea_hansen]

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

[Former Member]

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