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: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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@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: <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/08/2003 02:19 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
>Sent by: [EMAIL PROTECTED]
> 01/08/2003 11:44 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
_________________________________________________________________
MSN 8: advanced junk mail protection and 2 months FREE*. http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
