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. [EMAIL PROTECTED] -----Original Message----- [mailto:[EMAIL PROTECTED]] 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" <[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: Reardon, Bruce (CALBBAY) 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). -- 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).
