Home » Server Options » Data Guard » DR Rebuild - Data Restore issue (Oracle Database, 10.2.0.4, Solaris 10)
DR Rebuild - Data Restore issue [message #446765] Wed, 10 March 2010 05:25 Go to next message
gmaheshji
Messages: 6
Registered: March 2010
Location: Hyderabad
Junior Member
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
Re: DR Rebuild - Data Restore issue [message #447664 is a reply to message #446765] Wed, 17 March 2010 03:54 Go to previous message
gmaheshji
Messages: 6
Registered: March 2010
Location: Hyderabad
Junior Member
Thanks to every one.

I am glad to inform you that, issue is resolved.

Solution :- According to Doc ID 457769.1 I have changed the incarnation and its worked.

Once again thanks a ton for all your help...

Mahesh.G
Previous Topic: how to create standby database for RaC
Next Topic: drop and create log files
Goto Forum:
  


Current Time: Sun Dec 22 22:32:31 CST 2024