Re: RMAN recovery stuck

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" <ORACLE-L_at_fatcity.com> 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.
> > 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).
> >
>
> --
> Mladen Gogala
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
> 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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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