-
8i RMAN Duplicate DB failure!
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
-
Check for the
Ora81.. folder availability at the aux area.
What is the need for mapping instead you can point to the local folders at the auxiliary area with the help of the pfile.
-
Hi Engiri, 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")
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|