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... > > >>> [EMAIL PROTECTED] 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. >[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). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: James Howerton > 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: Deborah Lorraine 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).