RMAN freeze when duplicate db

From: bob123 <bob123_at_gmail.com>
Date: Sun, 1 Nov 2009 12:03:37 +0100
Message-ID: <4aed6b06$0$411$426a74cc_at_news.free.fr>



Hi,

I try to duplicate a database (10.2.0.3) with RMAN, the script freeze at the end of the duplication (executing Memory Script)

Any clue ?
Thanks in advance

The output below:

RMAN> run

2> {
3> allocate auxiliary channel c1 type disk;
4> set until time '22/10/2009 13:00';
5> set newname for datafile 'D:\DATA\ORACLE\T3O\T3O_SYSTEM01.DBF' to 
'D:\DATA\OR
ACLE\T3OB\T3OB_SYSTEM01.DBF';
6> set newname for datafile 'D:\DATA\ORACLE\T3O\T3O_UNDO01.DBF' to 'D:\DATA\ORAC
LE\T3OB\T3OB_UNDO01.DBF';
7> set newname for datafile 'D:\DATA\ORACLE\T3O\T3O_SYSAUX01.DBF' to 'D:\DATA\OR
ACLE\T3OB\T3OB_SYSAUX01.DBF';
8> duplicate target database to 'CBDT3OB' 9> logfile group 1 ('D:\DATA\ORACLE\T3OB\T3OB_LOG01.RDO') size 512000, 10> group 2 ('D:\DATA\ORACLE\T3OB\T3OB_LOG02.RDO') size 512000; 11> }

released channel: ORA_AUX_DISK_1
allocated channel: c1
channel c1: sid=320 devtype=DISK

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting Duplicate Db at 22/10/2009 15:17

contents of Memory Script:
{

   set until scn 320030;
   set newname for datafile 1 to
 "D:\DATA\ORACLE\T3OB\T3OB_SYSTEM01.DBF";    set newname for datafile 2 to
 "D:\DATA\ORACLE\T3OB\T3OB_UNDO01.DBF";
   set newname for datafile 3 to
 "D:\DATA\ORACLE\T3OB\T3OB_SYSAUX01.DBF";    restore
   check readonly
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 22/10/2009 15:17

channel c1: starting datafile backupset restore channel c1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to D:\DATA\ORACLE\T3OB\T3OB_SYSTEM01.DBF
restoring datafile 00002 to D:\DATA\ORACLE\T3OB\T3OB_UNDO01.DBF
restoring datafile 00003 to D:\DATA\ORACLE\T3OB\T3OB_SYSAUX01.DBF
channel c1: reading from backup piece
D:\DATA\ORACLE\T3O\SAUVE\BK_CBDT3O_23_7009 18980
channel c1: restored backup piece 1
piece handle=D:\DATA\ORACLE\T3O\SAUVE\BK_CBDT3O_23_700918980 tag=TAG20091022T114
300
channel c1: restore complete, elapsed time: 00:00:08 Finished restore at 22/10/2009 15:17
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CBDT3OB" RESETLOGS ARCHIVE
LOG
  MAXLOGFILES     32
  MAXLOGMEMBERS      2
  MAXDATAFILES       32
  MAXINSTANCES    16
  MAXLOGHISTORY     1752

 LOGFILE
  GROUP 1 ( 'D:\DATA\ORACLE\T3OB\T3OB_LOG01.RDO' ) SIZE 512000 ,   GROUP 2 ( 'D:\DATA\ORACLE\T3OB\T3OB_LOG02.RDO' ) SIZE 512000  DATAFILE
  'D:\DATA\ORACLE\T3OB\T3OB_SYSTEM01.DBF'  CHARACTER SET WE8MSWIN1252 contents of Memory Script:
{

   switch clone datafile all;
}
executing Memory Script

datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=700931875 filename=D:\DATA\ORACLE\T3OB\T3OB_UN
DO01.DBF
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=700931875 filename=D:\DATA\ORACLE\T3OB\T3OB_SY
SAUX01.DBF contents of Memory Script:
{

   set until time "22/10/2009 13:00";
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 22/10/2009 15:17

starting media recovery

archive log thread 1 sequence 4 is already on disk as file D:\DATA\ORACLE\T3O\AR
CHIVE\T3O_1_700673596_4.ARC
archive log filename=D:\DATA\ORACLE\T3O\ARCHIVE\T3O_1_700673596_4.ARC thread=1 s
equence=4
media recovery complete, elapsed time: 00:00:01 Finished recover at 22/10/2009 15:17

contents of Memory Script:
{

   shutdown clone;
   startup clone nomount ;
}
executing Memory Script Received on Sun Nov 01 2009 - 05:03:37 CST

Original text of this message