RE: RMAN Repository

Actually for recovery of the control file, you have to be in nomount mode. RMAN will connect to a database as long as the instance is up. So, to recover
from square one you need to get the instance runninng. In 9i, it's generally

possible to start an instance without even a parameter file, which is nice. Then
you can recover the SPFILE and the control file from the autobackup.

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 10:46 AM To: Multiple recipients of list ORACLE-L

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