Home » RDBMS Server » Backup & Recovery » Why RMAN wait for a long time?? (Oracle 10.2.0.4.0 WindowXP)
Why RMAN wait for a long time?? [message #514602] Tue, 05 July 2011 09:14 Go to next message
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 #514603 is a reply to message #514602] Tue, 05 July 2011 09:16 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior 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

enable SQL_TRACE to see where time is being spent

[Updated on: Tue, 05 July 2011 09:42]

Report message to a moderator

Re: Why RMAN wait for a long time?? [message #514605 is a reply to message #514602] Tue, 05 July 2011 09:31 Go to previous messageGo to next message
John Watson
Messages: 4611
Registered: January 2010
Location: Global Village
Senior Member
It looks to me as though the duplication has completed OK. Have you tried to logon to it?
Re: Why RMAN wait for a long time?? [message #514620 is a reply to message #514605] Tue, 05 July 2011 10:23 Go to previous messageGo to next message
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>
Re: Why RMAN wait for a long time?? [message #514714 is a reply to message #514602] Wed, 06 July 2011 01:08 Go to previous messageGo to next message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
Check the database instance's alert log file for messages.


Hemant K Chitale
Re: Why RMAN wait for a long time?? [message #514719 is a reply to message #514605] Wed, 06 July 2011 01:19 Go to previous message
John Watson
Messages: 4611
Registered: January 2010
Location: Global Village
Senior Member
OK, but did it actually work? What happens when you try to start it?
Previous Topic: Restore datafiles in another database
Next Topic: restoring from dbf
Goto Forum:
  


Current Time: Wed Oct 01 17:50:37 CDT 2014

Total time taken to generate the page: 0.12137 seconds