| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE : RMAN Repository
Good point, Jared.
An externally available repository is what is needed in the RMAN to make it complete; but the use of a full scale Oracle database for the repository makes it sort of complex. The repository then has to be protected at all costs. I generally use a multimaster replication setup, but use only one as a master. If, only if, Oracle had given us the ability to place a much simple setup for a repository, it would have been excellent. A repository does not contan that much of information anyway and certainly does not need the features like transaction processing, locking, etc.
Case in point - Veritas backup needs a simple text file for its repository; BrightStor uses Ingres (a relational database). In case of a disaster, we have to restore the repository first in case of BrightStor (takes time) and only then the restore can start. In case of Veritas, the recovery of the repository is as simple as opening up in vi and typing the lines. Guess which one is simpler?
Just a thought.
Arup Nanda
>From: Jared.Still_at_radisys.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: RE : RMAN Repository
>Date: Wed, 08 Jan 2003 14:53:26 -0800
>MIME-Version: 1.0
>Received: from newsfeed.cts.com ([209.68.248.164]) by
>mc8-f34.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Wed, 8 Jan
>2003 15:18:32 -0800
>Received: from fatcity.UUCP (uucp_at_localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id PAA54658;Wed, 8 Jan 2003 15:16:58 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0052AD42;
>Wed, 08 Jan 2003 14:53:26 -0800
>Message-ID: <F001.0052AD42.20030108145326_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: Jared.Still_at_radisys.com
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>Return-Path: root_at_fatcity.cts.com
>X-OriginalArrivalTime: 08 Jan 2003 23:18:32.0856 (UTC)
>FILETIME=[43053180:01C2B76C]
>
>But if you must apply archive logs that are newer than the control file,
>it is an atypical recovery. I can't recall how to do that at the moment.
>
>This makes an integral piece of the database also an integral piece
>of what should be an external recovery mechanism.
>
>Makes about as much sense as putting the RMAN repository on
>the same server as your production database.
>
>Jared
>
>
>
>
>
>
>Joe Testa <jtesta_at_dmc-it.com>
>Sent by: root_at_fatcity.com
> 01/08/2003 02:19 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
> cc:
> Subject: Re: RE : RMAN Repository
>
>
>its a pain in the arse but you have to pull out the backed up
>controlfile(you did backup the controlfile, eh?) out of the rman backup
>piece(i've got a script that will do it automagically based on the
>filename pieces you pass it).
>
>then once the backed up controlfile is restored, then you can do normal
>recovery procedure.
>
>joe
>
>
>Jared.Still_at_radisys.com wrote:
>
> >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: Joe Testa
> INET: jtesta_at_dmc-it.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: Arup Nanda INET: arupnanda_at_hotmail.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 Wed Jan 08 2003 - 18:03:42 CST
 |
 |