| jothi |
Posted: Mar 11, 2008 10:55:06 PM |
Total Post: 24
Joined: Aug, 2007
|
Hi,
Im using oracle 9i on windows..i recently used RMAN to clone my database.Even after taking a full backup my datafiles are not restored and i get the following errors.
RMAN> duplicate target database to 'rmanclone';
Starting Duplicate Db at 11-MAR-08
using channel ORA_AUX_DISK_1
datafile 10 not processed because file is offline
printing stored script: Memory Script
{
set until scn 5404956;
set newname for datafile 1 to
";\SYSTEM01.DBF";
set newname for datafile 2 to
";\UNDOTBS01.DBF";
set newname for datafile 3 to
";\CWMLITE01.DBF";
set newname for datafile 4 to
";\DRSYS01.DBF";
set newname for datafile 5 to
";\EXAMPLE01.DBF";
set newname for datafile 6 to
";\INDX01.DBF";
set newname for datafile 7 to
";\ODM01.DBF";
set newname for datafile 8 to
";\TOOLS01.DBF";
set newname for datafile 9 to
";\USERS01.DBF";
set newname for datafile 11 to
";\USERDATA.DBF";
set newname for datafile 12 to
";\STATS.DBF";
set newname for datafile 14 to
";\RMAN.DBF";
restore
check readonly
clone database
skip tablespace XDB ;
}
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
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 11-MAR-08
using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/11/2008 23:14:11
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 14 found to restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 11 found to 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
Can anyone help me to correct my error.
Thank you.. |
|
|
 Gitesh |
| Posted: Mar 12, 2008 04:51:13 AM |  |
|
Total Post: 322
Joined: May, 2005
|
It indicates that your backup hasn't register with RMAN. Did you take manual backup and tried to RMAN for cloning?
|
|
|
|
|
| jothi |
| Posted: Mar 12, 2008 11:31:01 AM | |
|
Total Post: 24
Joined: Aug, 2007
|
hi gitesh,
Thank you for your reply.I took backup using RMAN.i updated pfile of primary database with parameters db_file_name_convert and log_file_name_convert.but still i does not work.
|
|
|
|
|
| arun |
| Posted: Mar 13, 2008 01:12:43 AM | |
|
Total Post: 28
Joined: Sep, 2007
|
db_file_name_convert - you should not give this parameter in
a pfile of the the primary database.
Give this parameter is clone database pfile .
And From which machine you are running the cloning ?
if it is in primary database server then it will work,
it if is from the server,where you are going to clone, you need these
backup files in this server with same structure like the primary server.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
