RMAN duplicate hangs

From: Aragon, Gabriel (GE Commercial Finance) <gabriel.aragon_at_ge.com>
Date: Thu, 15 Jul 2004 16:18:11 -0400
Message-ID: <DA3854DCCE41EA42B603E39691388AC31643BACD@CINMLVEM05.e2k.ad.ge.com>

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 15 2004 - 18:02:40 CDT