Restore using backupset from another database
485386Feb 16 2006 — edited Feb 17 2006Hi 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.