Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

standby database requires recovery

bharathDBAJul 15 2011 — edited Jul 15 2011

Hi,

We have a dataguard setup for our 10g database.When we were doing the maintenance activity,We shutdown both the primary and while starting up primary came up but in the standby database we got the following error.The standby is now in mount state.

ORA-16004: backup database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '/data/ticsprod/p02/ticsprod_system01.dbf'

Now the archives are not getting applied at the standby site.

For this ,do we need to go for entire standby recreation or can we resolve the issue by taking the "INCREMENTAL FROM SCN..." backup from primary and applying at secondary.

Please suggest

Forgot to mention,we do not have the all archive logs required to recover the database.

Edited by: 870384 on Jul 15, 2011 12:35 AM

Edited by: 870384 on Jul 15, 2011 1:00 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 12 2011

Added on Jul 15 2011

#data-guard, #performance-availability

6 comments

2,733 views