Re: rman restore question

Note that when you configure controlfile autobackup on, then a backup controlfile will be saved to default location (dbs or database dir under $ORACLE_HOME) after most physical database structure changes such is adding a datafile, taking tablespace offline/online etc. This is the behaviour of 9.2.0.4 on W2k at least.

It may generate a good bunch of backup controfiles to Oracle software directory without your knowing...

Anyway, I have less than 23 hours to new year here, so I wish you happy ending of current year and happy new year! And you probably won't hear from me for next few days ;) Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, December 30, 2003 11:54 PM

> I think you can do "CONFIGURE CONTROLFILE AUTOBACKUP ON",
> which enables RMAN to automatically backup controlfile to
> a default location. Then you can restore the controlfile
> before you restore other database files.
>
> -----Original Message-----
> Sent: Tuesday, December 30, 2003 3:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Listers,
>
> I have a question about rman restore. Right now, I configured RETENTION
> POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> after a new rman full backup is done. The old backupset will be
> backup-ed to tape by system group. In case of the newly backupset on
> disk is corrupted and need to restore the 2 days old backupset from
> tape. Is there any way or command to restore the database using a
> already deleted obsoleted backupset? (from rman catalog point of view) I
> could find any command and example to restore a obsoleted backupset. Any
> comments will be appreciated.
>
> Many many thanks!
>
> Joan
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
> INET: joan.hsieh_at_tufts.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
> For technical support please email tech_support_at_dp7uptx.com or you can
> call (972)721-8257.
> This email has been scanned for all viruses by the MessageLabs Email
Security System.
>
> ________________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs Email
> Security System. For more information on a proactive email security
> service working around the clock, around the globe, visit
> http://www.messagelabs.com
> ________________________________________________________________________
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Roger Xu
> INET: roger_xu_at_dp7uptx.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).