Skip to Main Content

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!

How to recover standby by rman

yasirdbaOct 31 2013 — edited Nov 6 2013

Hello every one

Oracle 11g2 on window server 2008

For testing i have created standby server and shutdow it.

I have also schedule the increamental backup daily in the morning at 5:00 am.

Suppose if primary server has crashed at day time at 11:00 am as whole and standby database has lag of two days with respect to primary server

I have all archive log till 11:00 am, rman backup and control at 5:00 am.

Process that followed to recover the standby server .

1) restore the control file to standby database

2) copy the rman backup to standby server and catalog it.

3) restore the database successfully

4) recover database but it give errorĀ 

RMAN-03002: failure of recover command at 10/31/2013 14:55:40

ORA-19693: backup piece C:\BACKUP\STD_5TONPQ57_1_1 already included

5) i have issued alter database open but gives following error

ORA-10458: standby database requires recovery

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: 'C:\ORACLE\ORADATA\SLATE\SYSTEM01.DBF'

any help how to recover the standby server by rman incremental backup

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2013
Added on Oct 31 2013
11 comments
1,954 views