Re: RMAN recovery stuck

And that is why you have to use the controlfile from the time of the backup. Your current constrolfile doesn't know about back then, You can then roll forward to whenever you want.

HTH,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, August 15, 2002 4:03 PM

> Ruth - You suggested using a backup controlfile. What I have been doing is
> some time after the RMAN backup creates the backup set, I do a alter
> database backup controlfile to "file", and use that. Does that sound okay
to
> you?
> I really don't care when it recovers to, I'm just trying to perform a
> disaster recovery test so I can quit doing weekly non-RMAN backups.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Thursday, August 15, 2002 10:39 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
> --
> 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: 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).