RMAN freeze when duplicate db
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.DBFchannel 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