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 Duplicate database command..(Newbie..plese help)

phani marellaMar 17 2009 — edited Mar 17 2009

Hi everyone ,

Is there anything wrong am i doing in dupilcating the database using RMAN? I am practicing duplicate database using RMAN

This is what i have..

Target database: PROD
catalog database: PROD1REN

duplicate database: RMANDUP

I have my target database in archivelog mode and catalog too in archivelog mode.I just did my backup of the target database with RMAN "backup database command"

I did all the pre req steps for the duplicate database like..

1.creating a password file for RMANDUP
2.creating a pfile for RMANDUP
3.startup mount RMANDUP

rman catalog will/will@tnsnames_prod target sys/sys@tnsnames_prod1 auxiliary /;

DUPLICATE TARGET DATABASE TO RMANDUP;

restoring datafile 00004 to /u01/app/oracle/product/10.2.0/oradata/rmandup/users01.dbf
restoring datafile 00006 to /u01/app/oracle/product/10.2.0/oradata/rmandup/test1.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/product/10.2.0/oradata/prod/rman/06ka0bmj_1_1.bkp
ORA-19870: error reading backup piece /u01/app/oracle/product/10.2.0/oradata/prod/rman/05ka0bmj_1_1.bkp
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/oradata/prod/rman/05ka0bmj_1_1.bkp"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-19870: error reading backup piece /u01/app/oracle/product/10.2.0/oradata/prod/rman/06ka0bmj_1_1.bkp
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/oradata/prod/rman/06ka0bmj_1_1.bkp"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup

channel ORA_AUX_DISK_2: starting datafile backupset restore
channel ORA_AUX_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/product/10.2.0/oradata/rmandup/system01.dbf
restoring datafile 00003 to /u01/app/oracle/product/10.2.0/oradata/rmandup/sysaux01.dbf
restoring datafile 00005 to /u01/app/oracle/product/10.2.0/oradata/rmandup/example01.dbf
channel ORA_AUX_DISK_2: reading from backup piece /u01/app/oracle/product/10.2.0/oradata/prod/rman/01ka0073_1_1.bkp
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/app/oracle/product/10.2.0/oradata/rmandup/undotbs01.dbf
restoring datafile 00004 to /u01/app/oracle/product/10.2.0/oradata/rmandup/users01.dbf
restoring datafile 00006 to /u01/app/oracle/product/10.2.0/oradata/rmandup/test1.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/product/10.2.0/oradata/prod/rman/02ka0074_1_1.bkp
ORA-19870: error reading backup piece /u01/app/oracle/product/10.2.0/oradata/prod/rman/01ka0073_1_1.bkp
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/oradata/prod/rman/01ka0073_1_1.bkp"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-19870: error reading backup piece /u01/app/oracle/product/10.2.0/oradata/prod/rman/02ka0074_1_1.bkp
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/oradata/prod/rman/02ka0074_1_1.bkp"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/16/2009 21:53:50
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 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

why i am getting this error? I just did a fresh backup of the database..

please help me ..

thanks
phani

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2009

Added on Mar 17 2009

#performance-availability, #recovery-manager-rman

6 comments

3,095 views