 8i RMAN Duplicate DB failure! [message #112494] |
Fri, 25 March 2005 22:38  |
Ren
Messages: 3
Registered: February 2005
|
Junior Member |
|
|
Hi guys, hope someone can assist.
Two seperate machines, both windows 2000 and from within Windows I can map drives and access the other machine without a problem. My Oracle services run under the same Admin account that is used for the desktop login. When I try to duplicate the database from one system to the next I get the a failure as below. Also, I can login to each instance from sqlplus on the other workstation and a password file has been created.
Can someone please help me with this?
RMAN> run {
2> allocate auxiliary channel aux1 type disk;
3> duplicate target database to dupdb
4> nofilenamecheck;
5> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: aux1
RMAN-08500: channel aux1: sid=15 devtype=DISK
RMAN-03022: compiling command: Duplicate Db
RMAN-03027: printing stored script: Memory Script
{
set until scn 86826;
set newname for datafile 1 to
"C:\ORACLE\ORADATA\ICRMDB2\SYSTEM01.DBF";
set newname for datafile 2 to
"C:\ORACLE\ORADATA\ICRMDB2\RBS01.DBF";
set newname for datafile 3 to
"C:\ORACLE\ORADATA\ICRMDB2\USERS01.DBF";
set newname for datafile 4 to
"C:\ORACLE\ORADATA\ICRMDB2\TEMP01.DBF";
set newname for datafile 5 to
"C:\ORACLE\ORADATA\ICRMDB2\TOOLS01.DBF";
set newname for datafile 6 to
"C:\ORACLE\ORADATA\ICRMDB2\INDX01.DBF";
set newname for datafile 7 to
"C:\ORACLE\ORADATA\ICRMDB2\SM_DATA.ORA";
set newname for datafile 8 to
"C:\ORACLE\ORADATA\ICRMDB2\CHMART_DATA.ORA";
set newname for datafile 9 to
"C:\ORACLE\ORADATA\ICRMDB2\CLTPRO_DATA.ORA";
restore
check readonly
clone database
;
sql clone " CREATE CONTROLFILE REUSE SET DATABASE ^"dupdb^" RESETLOGS ARCHIVE
LOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 1
MAXLOGHISTORY 904
LOGFILE
GROUP 1 ( ''C:\ORACLE\ORADATA\ICRMDB2\REDO01.LOG'' ) SIZE 1048576 REUSE,
GROUP 2 ( ''C:\ORACLE\ORADATA\ICRMDB2\REDO02.LOG'' ) SIZE 1048576 REUSE,
GROUP 3 ( ''C:\ORACLE\ORADATA\ICRMDB2\REDO03.LOG'' ) SIZE 1048576 REUSE
DATAFILE
''C:\ORACLE\ORADATA\ICRMDB2\SYSTEM01.DBF''
CHARACTER SET UTF8";
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel aux1: starting datafile backupset restore
RMAN-08502: set_count=3 set_stamp=553870784 creation_time=25-MAR-05
RMAN-08089: channel aux1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to C:\ORACLE\ORADATA\ICRMDB2\SYSTEM01.DBF
RMAN-08523: restoring datafile 00003 to C:\ORACLE\ORADATA\ICRMDB2\USERS01.DBF
RMAN-08523: restoring datafile 00004 to C:\ORACLE\ORADATA\ICRMDB2\TEMP01.DBF
RMAN-08523: restoring datafile 00009 to C:\ORACLE\ORADATA\ICRMDB2\CLTPRO_DATA.OR
A
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: aux1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
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-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel aux1
RMAN-10035: exception raised in RPC: ORA-19505: failed to identify file "C:\ORAC
LE\ORA81\DATABASE\03GG6PE0_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP
IECE
|
|
|
|
|
|
| Re: 8i RMAN Duplicate DB failure! [message #112507 is a reply to message #112506] |
Sat, 26 March 2005 06:39  |
Ren
Messages: 3
Registered: February 2005
|
Junior Member |
|
|
Hi Mahesh, how do I do this? I mapped a drive on the auxiliary machine back to the target machine and also added the entries below in the init.ora file of the aux machine...
DB_FILE_NAME_CONVERT=(c:\ORACLE\ORADATA\ICRMDB2,x:\ORACLE\ORADATA\ICRMDB2)
LOG_FILE_NAME_CONVERT=("C:\ORACLE\ORADATA\ICRMDB2","x:\ORACLE\ORADATA\ICRMDB2")
|
|
|
|
| Re: 8i RMAN Duplicate DB failure! [message #112512 is a reply to message #112507] |
Sat, 26 March 2005 07:48 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
THis is the idea.
in machineA:
database is prodDB.
database files reside in c:\oradata\prodDB\*dbf
backupsets created by RMAN resides in C:\backup\prodDB\*.backupsets
in machineB:
database is dupDB.
database files reside in c:\oradata\dupbDB\*dbf
now machine B should see machineA:>C:\backup\prodDB\*.backupsets
as its local.
so just share the folder machineA:>C:\backup\prodDB\*.backupsets
between the machines so that just backupsets are available in both the machines. I may not be right with windows terminology.
in unix it is called as an NFS Mounted drive.
there should be a C:\backup\prodDB\*backupsets in both the machines.
Please refer the documenation.
Duplication procedre is explained step-by-step.
the ones you talk about
>>DB_FILE_NAME_CONVERT=(c:\ORACLE\ORADATA\ICRMDB2,x:\ORACLE\ORADATA\ICRMDB2)
>>LOG_FILE_NAME_CONVERT=("C:\ORACLE\ORADATA\ICRMDB2","x:\ORACLE\ORADATA\ICRMDB2")
are used by RMAN to convert the filenames ( directory structure).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
