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!

RMAN restore issue on duplicating database

Kundan SinhaSep 11 2016 — edited Sep 26 2016

Hi Team,

While trying to perform RMAN restore getting the below error:

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 09/11/2016 05:39:25

RMAN-05501: aborting duplication of target database

RMAN-05556: not all datafiles have backups that can be recovered to SCN 6191732466673

RMAN-03015: error occurred in stored script Memory Script

RMAN-06026: some targets not found - aborting restore

RMAN-06023: no backup or copy of datafile 126 found to restore

RMAN-06023: no backup or copy of datafile 97 found to restore

RMAN-06023: no backup or copy of datafile 49 found to restore

Source and Target servers are at same OS level(Linux).

Backup(Level 0 {full backup}) is copied from standby database to the target server. On my init.ora file, I have set CLUSTER_DATABASE parameter=false.

I have crosschecked for the datafile backups on source(prod) about datafile 126, 97, 49; which is already available on target server.

As I would be converting it to RAC database later, by making CLUSTER_DATABASE=true once the restore succeeds. I am attempting restore from node2, setting SID accordingly.

Please help me on the same, if some ideas can be shared.

Regards,

Kundan

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2016
Added on Sep 11 2016
6 comments
1,275 views