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!

Restore using backupset from another database

485386Feb 16 2006 — edited Feb 17 2006
Hi All,

I want to restore a dev database from backups taken of prod. The backups were taken on prod using RMAN and the files are backupsets not image copy. Before attempting the restore I am using RMAN on the DEVDB to catalog these prod backups using:

CATALOG START WITH '/ora_prod_backups/backup' NOPROMPT;

but i'm getting these messages and none of the files are cataloged:

RMAN-07518: Reason: Foreign database file DBID: 1093155429 Database Name: ORCL

This is because the prod db name (ORCL) is recorded in the backup file but i want to register these files with the DEVDB and restore DEVDB from these prod backups.

How do i get DEVDB to 'take' these backup files? Is this possible to register these files in a database with a different name than the db where the backups were taken? Please help....any advise would be greatly appreciated.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2006
Added on Feb 16 2006
10 comments
907 views