Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h09KjZX29575 for ; Thu, 9 Jan 2003 14:45:35 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h09KjYc29570 for ; Thu, 9 Jan 2003 14:45:34 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA30152; Thu, 9 Jan 2003 09:27:14 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0052B522; Thu, 09 Jan 2003 08:45:47 -0800 Message-ID: Date: Thu, 09 Jan 2003 08:45:47 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Orr, Steve" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Orr, Steve" Subject: RE: RE : RMAN Repository Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2B7FE.01B41330" ------_=_NextPart_001_01C2B7FE.01B41330 Content-Type: text/plain; charset="iso-8859-1" If you aren't using a repository all you have to do is make sure control file backups are part of the routine. There are 2 ways to backup the backup metadata: 1) the RMAN repository database; 2) backup controlfiles. Functionally and operationally they're pretty much the same. The only things you can't do with controlfile RMAN/database metadata is: 1) use previous "incarnations" of the database for recovery; 2) use database stored scripts. No big deal as far as I'm concerned. When RMAN first came out a separate repository database was a requirement. Subsequent releases added some functionality for using controlfiles. The vulnerability of losing the repository or losing the backup controlfile is about equivalent. The overhead of the repository database is more. With the initial releases of RMAN (EBU) Oracle was rightly criticized for the fact that you had to backup the database that holds information about the database you want to backup. Getting rid of this silliness seems reasonable to me. Steve Orr-man for RMAN, Bozeman, Montana -----Original Message----- Sent: Wednesday, January 08, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Importance: High 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" Sent by: root@fatcity.com 01/08/2003 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L 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 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 ------_=_NextPart_001_01C2B7FE.01B41330 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: RE : RMAN Repository

If you aren't using a repository all you have to do = is make sure control file backups are part of the routine. There are 2 = ways to backup the backup metadata: 1) the RMAN repository database; 2) = backup controlfiles.

Functionally and operationally they're pretty much = the same. The only things you can't do with controlfile RMAN/database = metadata is: 1) use previous "incarnations" of the database = for recovery; 2) use database stored scripts. No big deal as far as I'm = concerned.

When RMAN first came out a separate repository = database was a requirement. Subsequent releases added some = functionality for using controlfiles. The vulnerability of losing the = repository or losing the backup controlfile is about equivalent. The = overhead of the repository database is more. With the initial releases = of RMAN (EBU) Oracle was rightly criticized for the fact that you had = to backup the database that holds information about the database you = want to backup. Getting rid of this silliness seems reasonable to = me.


Steve Orr-man for RMAN,
Bozeman, Montana


-----Original Message-----
From: Jared.Still@radisys.com [mailto:Jared.Still@radisys.com]
Sent: Wednesday, January 08, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE : RMAN Repository
Importance: High


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@verizon.com>
Sent by: root@fatcity.com
 01/08/2003 11:44 AM
 Please respond to ORACLE-L
 
        = To:     Multiple recipients of list ORACLE-L = <ORACLE-L@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

------_=_NextPart_001_01C2B7FE.01B41330-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: sorr@rightnow.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@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).