Home » RDBMS Server » Backup & Recovery » Duplicate target RMAN cloning (10g, 10.2.0.1, OEL)
Duplicate target RMAN cloning [message #583707] Fri, 03 May 2013 05:19 Go to next message
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
Re: Duplicate target RMAN cloning [message #583713 is a reply to message #583707] Fri, 03 May 2013 06:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you make RMAN be aware of it?
If the location of RMAN backupsets are different from the source machine,
you have to catalog them.
http://www.oracle-base.com/articles/10g/rman-enhancements-10g.php#cataloging_backup_pieces
Re: Duplicate target RMAN cloning [message #584029 is a reply to message #583713] Wed, 08 May 2013 01:39 Go to previous message
forkausar
Messages: 4
Registered: May 2013
Junior Member
following link explain all required steps to create duplicate database using rman duplicate command.

http://www.learnoracledatabase.com/rman/duplicating-database-using-rman-duplicate-command

[Updated on: Wed, 08 May 2013 02:04]

Report message to a moderator

Previous Topic: how to create auxiliary instance
Next Topic: get DBID of crashed database
Goto Forum:
  


Current Time: Mon Dec 22 16:08:22 CST 2014

Total time taken to generate the page: 0.32343 seconds