Oracle 10.2.0.5
Linux 5
I am creating a duplicate database using RMAN based on Oracle's documentation. I was successful up to running the duplicate command.
Here is my command:
DUPLICATE TARGET DATABASE vlab pfile='/<complete path of pfile>';
When I run the command, it tries to read from the backup files on production database - which is on anotehr node.
Before then, I had backup piece copied to the node with the duplicate database.
I ran this command to catalog the backup piece:
catalog start with '/<complete path to backuppiece>'
Error: no files to be unknown to the database
On the other hand, when I run the command without cataloging the backuppiece, I get this error:
Partial view of error- restoring datafile 00021 to /oraappl/pca/vptch/vlabdata/staff101.dbf restoring datafile 00022 to /oraappl/pca/vptch/vlabdata/staff201.dbf restoring datafile 00023 to /oraappl/pca/vptch/vlabdata/tools01.dbf restoring datafile 00024 to /oraappl/pca/vptch/vlabdata/vol01.dbf restoring datafile 00025 to /oraappl/pca/vptch/vlabdata/volsup101.dbf restoring datafile 00026 to /oraappl/pca/vptch/vlabdata/volsup201.dbf channel ORA_AUX_DISK_1: reading from backup piece /oraappl/pca/backups/weekly/vproddat ackupset/2013_08_27/o1_mf_nnndf_TAG20130827T083750_91s7dz0r_.bkp ORA-19870: error reading backup piece /oraappl/pca/backups/weekly/vproddata/rman/VPROD 3_08_27/o1_mf_nnndf_TAG20130827T083750_91s7dz0r_.bkp ORA-19505: failed to identify file "/oraappl/pca/backups/weekly/vproddata/rman/VPROD/b 08_27/o1_mf_nnndf_TAG20130827T083750_91s7dz0r_.bkp" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: failover to previous backup RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/28/2013 12:25:28 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 26 found to restore RMAN-06023: no backup or copy of datafile 25 found to restore RMAN-06023: no backup or copy of datafile 24 found to restore RMAN-06023: no backup or copy of datafile 23 found to restore RMAN-06023: no backup or copy of datafile 22 found to restore RMAN-06023: no backup or copy of datafile 21 found to restore