RMAN duplicate hangs
- From: "Aragon, Gabriel (GE Commercial Finance)" <gabriel.aragon@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Jul 2004 16:18:11 -0400
Hello list,=20
I'm trying to duplicate a DB from host A to host B using RMAN, after =
dealing with the directories stuff (having the backup files in the same =
path as the original) I tried once again to run the process, from host =
B, but after creating the DB and restoring the datafiles in host B, =
after finishing media recovery it hangs up.. and then crashes without =
creating the redo logs.
-this is the last entry to the log file -->
media recovery complete
Finished recover at 15-JUL-04
printing stored script: Memory Script
{
shutdown clone;
startup clone nomount ;
}
executing script: Memory Script
-I'm monitoring the process with this query:
select sid, serial#, context,
round(sofar/totalwork*100,2) "% Complete",
substr(to_char(sysdate,'yymmdd hh24:mi:ss'),1,15) "Time Now",
elapsed_seconds, opname
from v$session_longops;
-and when the process hangs, the query displays this:
31 6288 0 100 040715 14:50:58 43 Hash Join
12 9025 13 100 040715 14:50:58 0 RMAN: aggregate =
output
16 14826 0 100 040715 14:50:58 10 Hash Join
18 10860 44 100 040715 14:50:58 288197021 !/=FF=F9'??=B1'??
29 4292 44 100 040715 14:50:58 288202572 !/=FF=F9'?=A3t'??
I don't know what are the last two rows. After a couple of hours the =
process stops.
This is my script:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE AUXNAME FOR DATAFILE 1 TO =
'F:\ORACLE\oradata\TESTING\datafiles\SYSTEM01.DBF';
CONFIGURE AUXNAME FOR DATAFILE 2 TO =
'F:\ORACLE\oradata\TESTING\datafiles\UNDOTBS01.DBF';
.
.
RUN {
ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
SET UNTIL TIME 'SYSDATE-1';
DUPLICATE TARGET DATABASE TO 'testing'
LOGFILE
GROUP 1 ('D:\ORACLE\ORADATA\TESTING\REDO01.LOG',
'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO01.LOG') SIZE =
50M,
GROUP 2 ('D:\ORACLE\ORADATA\TESTING\REDO02.LOG',
'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO02.LOG') SIZE =
50M,
GROUP 3 ('D:\ORACLE\ORADATA\TESTING\REDO03.LOG',
'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO03.LOG') SIZE =
50M;
}
CONFIGURE AUXNAME FOR DATAFILE 1 CLEAR;=20
CONFIGURE AUXNAME FOR DATAFILE 2 CLEAR;=20
.
.
Am I missing something or doing something wrong? Any ideas?
TIA
Gabriel
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
