Duplicate target RMAN cloning [message #583707] |
Fri, 03 May 2013 05:19 |
ishika_20
Messages: 339 Registered: December 2006 Location: delhi
|
Senior Member |
|
|
Dear All,
Let me tel you the steps which i had done .
1) have taken backup at target side.
2) through SCP, transferred all the file to auxiliary side.
3) Ran the duplicate command at auxiliary side.
After running the command, i got the below error. Kindly assist me on the same.
hish@localhost db_1]$ rman target sys/oracle@suman auxiliary /
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 12 09:13:43 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SUMAN (DBID=3778352561)
connected to auxiliary database: ASHISH (not mounted)
RMAN> duplicate target database to 'ASHISH' nofilenamecheck;
Starting Duplicate Db at 12-APR-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=157 devtype=DISK
contents of Memory Script:
{
set until scn 243058;
set newname for datafile 1 to
"/u01/oracle/oradata/ashish/system.dbf";
set newname for datafile 2 to
"/u01/oracle/oradata/ashish/undotbs1.dbf";
set newname for datafile 3 to
"/u01/oracle/oradata/ashish/sysaux.dbf";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 12-APR-13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oracle/oradata/ashish/system.dbf
restoring datafile 00002 to /u01/oracle/oradata/ashish/undotbs1.dbf
restoring datafile 00003 to /u01/oracle/oradata/ashish/sysaux.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u02/suman10g/flash_recovery_area/SUMAN/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T064440_8q3v024s_.bkp
ORA-19870: error reading backup piece /u02/suman10g/flash_recovery_area/SUMAN/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T064440_8q3v024s_.bkp
ORA-19505: failed to identify file "/u02/suman10g/flash_recovery_area/SUMAN/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T064440_8q3v024s_.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_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oracle/oradata/ashish/system.dbf
restoring datafile 00002 to /u01/oracle/oradata/ashish/undotbs1.dbf
restoring datafile 00003 to /u01/oracle/oradata/ashish/sysaux.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u02/suman10g/flash_recovery_area/SUMAN/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T022047_8q3ck9f9_.bkp
ORA-19870: error reading backup piece /u02/suman10g/flash_recovery_area/SUMAN/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T022047_8q3ck9f9_.bkp
ORA-19505: failed to identify file "/u02/suman10g/flash_recovery_area/SUMAN/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T022047_8q3ck9f9_.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 04/12/2013 09:14:37
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 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
Regards,
Ishika
|
|
|
|
|