Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Using no rman repository for rman recoveries

Using no rman repository for rman recoveries

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Thu, 09 Jan 2003 08:35:46 -0800
Message-ID: <F001.0052B4C0.20030109083546@fatcity.com>


Robert.. Using controlfile only recoveries...(not using catalog)

         We have people spouting that we should only use controlfile
         recoveries with RMAN because an Oracle instructor said so and
         said this is the future direction... 
         I would love to do it..but what if I have to 
         rebuild the controlfile becuase I hit a maximum limit like files?
         Would not I lose all my backup history etc... or is there a way to 
         work around that and create some redundancy for the history
information?
         Can it be done for 8i and/or 9i?
         

Brian Spears

-----Original Message-----
Sent: Thursday, January 09, 2003 10:14 AM To: Multiple recipients of list ORACLE-L

In 9i Oracle can handle control file recoveries just fine without a repository if configured correctly.
In 8i, you can actually recover the control file even without a repository but you have to use the dbms_backup_restore package to do so.

I have not heard anything about the repository going away. I wonder how they would support RMAN scripting and enterprise backup and recovery reporting in this case.

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

> 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: 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: Spears, Brian
  INET: BSpears_at_Limitedbrands.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).
Received on Thu Jan 09 2003 - 10:35:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US