Skip to Main Content

Oracle Database Discussions

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!

DR Rebuild - Data restore issue

726830Mar 10 2010 — edited Mar 12 2010
Hi Experts,

While doing DR rebuild ( physical standby ), after restoring standby controlfile in DR location, i am getting below error while restoring
database. I took backup through RMAN ( hotbackup ) from primary database.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/10/2010 11:58:32
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 28 found to restore
RMAN-06023: no backup or copy of datafile 27 found to restore

I tried the below options :-

1. Duplicate command :- while using duplicate command also i got the same error
2. " catalog backuppiece " of all backup pieces copied from primary database.
3. I used restore with set until time option also but no luck.

In all cases i got same error. How can i restore primary database backup in DR ? Pls help.

Mahesh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2010
Added on Mar 10 2010
10 comments
3,083 views