RE: RMAN recovery stuck

I was thinking along those same lines...set your NLS_DATE_FORMAT environment variable, for example, to 'YYYY-MM-DD:HH24:MI:SS' and then use a matching format in your script: set until time '2002-02-03:03:30:59';

This format is what I use.

Debi

At 01:13 PM 8/15/2002 -0800, James Howerton wrote:
>Dennis,
>
>Annother thought, I had similar hang problems while trying to clone a
>database to annother box. I can't remember exactly what I did, it was
>too long ago. I set the until time in a different format than you are
>using.
>
>run {
>
>set until time '03-FEB-2002 03:30:59';
>
>allocate channel d1type disk ...
>
>...
>
>}
>
>HTH
>...JIM...
>
> >>> DWILLIAMS_at_LIFETOUCH.COM 8/15/02 2:58:31 PM >>>
>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.
>dwilliams_at_lifetouch.com
>
>-----Original Message-----
>Sent: Wednesday, August 14, 2002 2:23 PM
>To: '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: 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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: James Howerton
> INET: jhowerton_at_uabmc.edu
>
>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: Deborah Lorraine
  INET: dlorraine_at_ucdavis.edu

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).