RE: RMAN recovery stuck

Robert, Tim, Mladen, Bruce - Thanks for the excellent suggestions. I will try them today.

Bruce - Yes, you have an excellent memory. Not only for the Metalink note, but recalling my posting from a month ago. I was pulled into some other projects and just now getting back to this one, trying the last round of suggestions. Also, I thought maybe a control-file based recovery was just my own offbeat idea until Joe mentioned he was using that.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
[mailto:Bruce.Reardon_at_comalco.riotinto.com.au] Sent: Wednesday, August 14, 2002 11:33 PM To: Multiple recipients of list ORACLE-L

This reminded me of a Metalink note I once found. Dennis - you might want to look at Note:145624.1 (RMAN: Resolving an RMAN Hung Job) for some more hints & information.

        Tim - the note mentions the debug command line parameter but doesn't show the "trace=1" phrase so its good to learn that.

Dennis - Is this the same hanging issue you had a month or so ago?

Regards,
Bruce Reardon

-----Original Message-----
Sent: Thursday, 15 August 2002 13:23

Call RMAN from command-line as follows:

    rman nocatalog log=<logfilename> debug trace=<tracefilename>

Both the "logfilename" and "tracefilename" should have copious amounts of output, which can provide a clue.

When you allocate the channel, make sure to add the phrase "trace=1" to the end of the ALLOCATE command. This will produce ".trc" files in your USER_DUMP_DEST directory with additional diagnostic output...

Hope this helps...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>

> 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.
> dwilliams_at_lifetouch.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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: ListGuru_at_fatcity.com (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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).