Okay, I implemented everyone's comments and re-executed the RMAN recovery.
Here is what I did and the results.
1. Action: Removed "alter database open resetlogs" from the run statement.
Result: No change.
2. Action: Added trace=1 to the allocate channel command.
Result: No trace file is produced in udump.
3. Action: Reviewed Note 145624.1
Result: Did not see the solution to my problem. Most of the suggestions
seem appropriate to backup rather than recovery jobs.
4. Action: Added log and debug trace statements to rman invocation line.
Result: Produced log and trace file. The trace file at the point of the
recovery hang contains the following:
krmxrpc: xc=5372006336 kpurpc2 returned 0
krmxrpc: xc=5372006336 RPC #10 completed immediately
RMAN-08523: restoring datafile 00006 to /ora05/ams/data0501.dbf
krmxrpc: xc=5372006336 kpurpc2 returned 0
krmxrpc: xc=5372006336 RPC #11 completed immediately
RMAN-08523: restoring datafile 00017 to /ora05/ams/rbs01.dbf
krmxrpc: xc=5372006336 kpurpc2 returned 0
krmxrpc: xc=5372006336 RPC #12 completed immediately
RMAN-08523: restoring datafile 00025 to /ora05/ams/mls_data0401.dbf
krmxrpc: xc=5372006336 kpurpc2 returned 3123
krmxrpc: xc=5372006336 starting longrunning RPC #13 to target:
DBMS_BACKUP_RESTO
RE.RESTOREBACKUPPIECE
krmxr: xc=5372006336 started long running rpc
krmxpoq: xc=5372006336, action="0000013 STARTED", col_l=15, ind=0, sid=13
krmxr: callback returned TRUE, skipping sleep
krmxpoq: xc=5372006336, action="0000013 STARTED", col_l=15, ind=0, sid=13
krmxr: sleeping for 1 seconds
krmxpoq: xc=5372006336, action="0000013 STARTED", col_l=15, ind=0, sid=13
krmxr: sleeping for 2 seconds
krmxpoq: xc=5372006336, action="0000013 STARTED", col_l=15, ind=0, sid=13
krmxr: sleeping for 4 seconds
krmxpoq: xc=5372006336, action="0000013 STARTED", col_l=15, ind=0, sid=13
krmxr: sleeping for 8 seconds
And the trace continues with this statement.
Any suggestions would be appreciated, as are the suggestions to this point.
I'm about ready to think it is TAR time.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Wednesday, August 14, 2002 2:23 PM
To: '[EMAIL PROTECTED]'
I am trying to perform an RMAN disaster recovery task. While I use an RMAN
catalog to make backups, I am trying to recover using just the control file
information.
Oracle 8.1.6, Compaq/HP Tru64
I start RMAN with
rman target sys/password nocatalog
then,
startup mount
run {
set until time "to_date('08/11/2002 01:00:00','MM/DD/YYYY HH24:MI:SS')";
allocate channel d1 type disk;
restore database;
recover database;
alter database open resetlogs;
}
Everything appears normal for awhile. In the alert log RMAN tries to find
each file, doesn't find them. Then it successfully recovers 5 data files
(including system and rollback) and reports success in the alert log. Then .
. . nothing for hours. RMAN doesn't return an error. The RMAN shadow
processes are still present but with no CPU consumption. Nothing is written
to the alert log.
I check V$SESSION_WAIT, and the only entry for the RMAN shadow
processes is one is SQL*Net message to client with seconds_in_wait = 0,
state = waited unknown time.
In V$SYSTEM_EVENT, time_waited and average_wait are zero for all
events. The following events have values of total_waits that are increasing:
Increase in total_waits in 10-minutes
rdbms ipc message 401
pmon timer 57
control file parallel write 56
SQL*Net message to client 24
SQL*Net message from client 24
virtual circuit status 5
dispatch timer 3
smon timer 1
Archiving is turned off.
I have attempted this recovery many times using different RMAN backup sets,
but the system always hangs at this point.
Any ideas would be appreciated.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
