Home » RDBMS Server » Backup & Recovery » error during creating clone database using RMAN
error during creating clone database using RMAN [message #336849] Tue, 29 July 2008 03:54 Go to next message
raj_roshan_009
Messages: 29
Registered: May 2008
Junior Member
Hi All,

Database: Oracle 9i
OS: window

i am creating clone database using RMAN.
but there is some error as:-

RMAN> duplicate target database to DUP
2> pfile=C:\oracle\admin\DUP\pfile\init.ora
3> logfile
4> 'C:\oracle\oradata\DUP\redo01.dbf' size 100m,
5> 'C:\oracle\oradata\DUP\redo02.dbf' size 100m,
6> 'C:\oracle\oradata\DUP\redo03.dbf' size 100m;

Starting Duplicate Db at 29-JUL-08
using target database controlfile instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=11 devtype=DISK

printing stored script: Memory Script
{
set until scn 639436;
set newname for datafile 1 to
"C:\ORACLE\ORADATA\DUP\SYSTEM01.DBF";
set newname for datafile 2 to
"C:\ORACLE\ORADATA\DUP\UNDOTBS01.DBF";
set newname for datafile 3 to
"C:\ORACLE\ORADATA\DUP\CWMLITE01.DBF";
set newname for datafile 4 to
"C:\ORACLE\ORADATA\DUP\DRSYS01.DBF";
set newname for datafile 5 to
"C:\ORACLE\ORADATA\DUP\EXAMPLE01.DBF";
set newname for datafile 6 to
"C:\ORACLE\ORADATA\DUP\INDX01.DBF";
set newname for datafile 7 to
"C:\ORACLE\ORADATA\DUP\TOOLS01.DBF";
set newname for datafile 8 to
"C:\ORACLE\ORADATA\DUP\USERS01.DBF";
set newname for datafile 9 to
"C:\ORACLE\ORADATA\DUP\RAJ.DBF";
restore
check readonly
clone database
;
}
executing script: Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 29-JUL-08

using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 07/29/2008 14:01:37
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to 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

what is the reason behind this error.

Regards
Roshan.

  • Attachment: aa.txt
    (Size: 2.82KB, Downloaded 185 times)
Re: error during creating clone database using RMAN [message #336932 is a reply to message #336849] Tue, 29 July 2008 07:10 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

common error in duplicating database. To solve you can have a look at,
http://arjudba.blogspot.com/2008/04/rman-06026-rman-06023-during-restore.html
Re: error during creating clone database using RMAN [message #337182 is a reply to message #336932] Wed, 30 July 2008 02:06 Go to previous message
raj_roshan_009
Messages: 29
Registered: May 2008
Junior Member
Thanks Arju.
Previous Topic: auto down database when perform oracle suggest backup
Next Topic: Tape Backup Documentation
Goto Forum:
  


Current Time: Sat Dec 10 07:23:47 CST 2016

Total time taken to generate the page: 0.05215 seconds