Why RMAN wait for a long time?? [message #514602] |
Tue, 05 July 2011 09:14 |
wxfjordan
Messages: 92 Registered: December 2006
|
Member |
|
|
I want create a duplication database with RMAN in the same host. But the script run in RMAN always waits for a long time and cannot be completed. How to analyze the problem? Please take a look as follow:
OS: XP
DB:
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
C:\>rman target sys/sys@xpdb auxiliary /
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jul 1 20:55:51 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: XPDB (DBID=574174897)
connected to auxiliary database: DUPDB (not mounted)
RMAN> run {
2> set newname for datafile 1 to 'C:\dupdb\SYSTEM01.DBF';
3> set newname for datafile 2 to 'C:\dupdb\UNDOTBS01.DBF';
4> set newname for datafile 3 to 'C:\dupdb\SYSAUX01.DBF';
5> set newname for datafile 4 to 'C:\dupdb\USERS01.DBF';
6> set newname for datafile 5 to 'C:\dupdb\TERRYTS.DBF';
7> set newname for datafile 6 to 'C:\dupdb\NOWITZKITS.DBF';
8> SET NEWNAME FOR TEMPFILE 1 to 'C:\dupdb\TEMP01.DBF';
9> duplicate target database to dupdb logfile
10> 'C:\dupdb\REDO01.LOG' size 20M,
11> 'C:\dupdb\REDO02.LOG' size 20M,
12> 'C:\dupdb\REDO03.LOG' size 20M;
13> }
executing command: SET NEWNAME
using target database control file instead of recovery catalog
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting Duplicate Db at 2011-07-01 20:58:51
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK
contents of Memory Script:
{
set until scn 2864235;
set newname for datafile 1 to
"C:\DUPDB\SYSTEM01.DBF";
set newname for datafile 2 to
"C:\DUPDB\UNDOTBS01.DBF";
set newname for datafile 3 to
"C:\DUPDB\SYSAUX01.DBF";
set newname for datafile 4 to
"C:\DUPDB\USERS01.DBF";
set newname for datafile 5 to
"C:\DUPDB\TERRYTS.DBF";
set newname for datafile 6 to
"C:\DUPDB\NOWITZKITS.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
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 2011-07-01 20:58:53
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\DUPDB\SYSTEM01.DBF
restoring datafile 00002 to C:\DUPDB\UNDOTBS01.DBF
restoring datafile 00003 to C:\DUPDB\SYSAUX01.DBF
restoring datafile 00004 to C:\DUPDB\USERS01.DBF
restoring datafile 00005 to C:\DUPDB\TERRYTS.DBF
restoring datafile 00006 to C:\DUPDB\NOWITZKITS.DBF
channel ORA_AUX_DISK_1: reading from backup piece C:\BACKUP\RMAN_BACKUP\XPDB_26_1_20110701.DBF
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=C:\BACKUP\RMAN_BACKUP\XPDB_26_1_20110701.DBF tag=TAG20110701T203126
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:06
Finished restore at 2011-07-01 20:59:59
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUPDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'C:\dupdb\REDO01.LOG' SIZE 20 M ,
GROUP 2 'C:\dupdb\REDO02.LOG' SIZE 20 M ,
GROUP 3 'C:\dupdb\REDO03.LOG' SIZE 20 M
DATAFILE
'C:\DUPDB\SYSTEM01.DBF'
CHARACTER SET AL32UTF8
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
released channel: ORA_AUX_DISK_1
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=755384402 filename=C:\DUPDB\UNDOTBS01.DBF
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=755384402 filename=C:\DUPDB\SYSAUX01.DBF
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=755384402 filename=C:\DUPDB\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=755384402 filename=C:\DUPDB\TERRYTS.DBF
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=755384403 filename=C:\DUPDB\NOWITZKITS.DBF
contents of Memory Script:
{
set until scn 2864235;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 2011-07-01 21:00:03
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=155 devtype=DISK
starting media recovery
archive log thread 1 sequence 113 is already on disk as file C:\ORACLE\PRODUCT\10.2.0\ARCHIVELOG\ARC00113_0754052005.001
archive log filename=C:\ORACLE\PRODUCT\10.2.0\ARCHIVELOG\ARC00113_0754052005.001 thread=1 sequence=113
media recovery complete, elapsed time: 00:00:02
Finished recover at 2011-07-01 21:00:07
contents of Memory Script:
{
shutdown clone;
startup clone nomount ;
}
executing Memory Script
-- Problem in here and wait for a long time.
-- How to anaylze???
(^_^)... help...
|
|
|
|
|
Re: Why RMAN wait for a long time?? [message #514620 is a reply to message #514605] |
Tue, 05 July 2011 10:23 |
wxfjordan
Messages: 92 Registered: December 2006
|
Member |
|
|
I just give several "enter" key in RMAN and see some error messages as follow:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/05/2011 22:18:50
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operation
RMAN>
RMAN>
RMAN>
|
|
|
|
|