You have to use the backup controlfile to do a point-in-time recovery that is prior to the current time. This may be your probelm. Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 12:28 AM
> The problem is probably in the "RESETLOGS" part. Do you have many large log files? > If you do, your instance is trying to initialize them all. Take a look at the system > monitor and observe the CPU consumption. If it is large, you have a problem. If it isn't, > use sar -b 5 50 or something alike and see how many preads/pwrites are you getting. > Many preads/pwrites means that your database software is doing IO. for 8 redo groups, > consisting of two members each, 512M per member. it used to take almost 40 minutes to do "open > resetlogs", after a successful recovery. Solution was a cheap one, FC/AL based EMC Symmetrix > 1+0 RAID with 32 GB cache. That has helped. Such solution costs $.25 per MB of the effective > storage, which means that 1TB costs $250,000. > > On 2002.08.14 16:28 DENNIS WILLIAMS wrote: > > 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). > > > > -- > Mladen Gogala > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mladen Gogala > 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: Ruth Gramolini 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).