error during creating clone database using RMAN [message #336849] |
Tue, 29 July 2008 03:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 1323 times)
|
|
|
|
|