Re: RMAN Repository

One question, don't you have to have the database in no mount state to recover the controlfile in 8i? You do in 8.0.x.

Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 09, 2003 10:24 AM

> 9i Offers automated recovery of the control file. All you need to know is
> where you are making your
> control file backups to (tape or disk), and the DBID of the database you
> wish to recover the control
> file of. If you forget the DBID, not to worry because it's stored in the
> file name of the backup
> pieces that contain the control file so you can play around and find the
> DBID that way.
>
> 9i RMAN is much easier in this respect than earlier RMAN versions.
>
> Still, even if you loose your control file in 8i, it's not too hard to
> recover that control file
> as long as you know where your backup pieces are. You just need to mount
the
> instance and use
> dbms_backup_restore to recover the control file from the backup set. It's
> perhaps not the most
> straight forward method of doing this, but it works.
>
> Shameless plug - This is all documented in Oracle9i RMAN Backup and
Recovery
> by Oracle Press. :-)
>
> RF
>
> Robert G. Freeman
> Technical Management Consultant
> TUSC - The Oracle Experts www.tusc.com
> 904.708.5076 Cell (it's everywhere that I am!)
> Author of several books you can find on Amazon.com!
>
>
>
> -----Original Message-----
> Sent: Thursday, January 09, 2003 8:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Igor - Hopefully you won't lose your repository at the same time you lose
> all your production database controlfiles. However, if that is happens,
> hopefully you were outside the computer room at that moment. ;-)
> So, you should be able to recover your repository and/or take a fresh
> backup.
> I should point out that even if you use an RMAN repository, the
recovery
> information is still stored in the control files, so you can still perform
a
> control file recovery. But Jared is correct that it is much more difficult
> if you must try to recover the control file from the RMAN backup piece.
That
> is why I separately back up the control file (binary backup) after the
RMAN
> backup. I understand this is all much better in 9i.
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Thursday, January 09, 2003 7:49 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Doesn't the same apply to database repository, when it's lost?
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, January 08, 2003 4:14 PM
>
>
> > And how does one go about restoring a database when all control files
> > are lost, and the only recovery data is stored in the control file?
> >
> > This doesn't sound very reasonable.
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > "Deshpande, Kirti" <kirti.deshpande_at_verizon.com>
> > Sent by: root_at_fatcity.com
> > 01/08/2003 11:44 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: RE : RMAN Repository
> >
> >
> > Joe,
> > That's what I have heard (from 2 Oracle University
> > Professors/Lecturers/Demonstrators). But no one would tell me when it
may
> > happen. We do not use RMAN (yet) so I did not pursue it further.
> >
> > - Kirti
> >
> > -----Original Message-----
> > Sent: Wednesday, January 08, 2003 1:08 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > <snip>
> >
> > Obilgatory oracle statement/question: rumor has it by some instructors
> > that RMAN repository is going away and only control file recoveries
> > will be possible, truth or fiction?
> >
> > joe
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Deshpande, Kirti
> > INET: kirti.deshpande_at_verizon.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:
> > INET: Jared.Still_at_radisys.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: Igor Neyman
> INET: ineyman_at_perceptron.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: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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: Freeman Robert - IL
> INET: FREEMANR_at_tusc.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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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