SQL from text files is possible via external tables in 9i,
or via Perl and DBD::CSV ( if comma delimited )
possible, but not my favorite way to access data. :)
Jared
"Arup Nanda" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/09/2003 07:24 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: RE : RMAN Repository
Huh!!!
<Quote>
If the backup was made while the repository was in use for
other backups, it may be in a logically inconsistent state from
the RMAN perspective.
</Quote>
That sent a shiver through the spine, Jared. I admit, I never tested the
recovery of the RMAN repository and never (shame on me!) considered the
effect of incomplete recovery of the catalog.
Others, any ideas? specifically the effect of losing the catalog database
and recreating it from a hot backup? Robert Freeman, perhaps?
This is another reason why I dislike the idea of a database to store the
recovery catalog. Granted, the catalog needs to stored somewhere and it
happens to be in (surprise! surprise!!) an Oracle database; but it's more
akin to driving a leather interior tank to work everyday. It could have
been
plain and simple like a text file. A sql based interface would not have
been
possible; but then again is it there, really? The RMAN scripts could have
been adapted to query and manipulate the ascii text file. Just my
thoughts!
Arup
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: RE : RMAN Repository
>Date: Thu, 09 Jan 2003 15:19:43 -0800
>MIME-Version: 1.0
>Received: from newsfeed.cts.com ([209.68.248.164]) by
>mc2-f20.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 9
Jan
>2003 16:23:24 -0800
>Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id QAA72977;Thu, 9 Jan 2003 16:19:12 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id
0052BE7E;
>Thu, 09 Jan 2003 15:19:43 -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: 10 Jan 2003 00:23:24.0598 (UTC)
>FILETIME=[7D17A560:01C2B83E]
>
>Hot backup of the repository is fine as long as you can be
>assured that all files needed for a complete recovery are
>going to be available.
>
>Recover a hot backup of an RMAN repository to another
>server using imcomplete recovery, ( your RMAN server
>burned to a crisp, drives and all ), and you may or may not
>have a good repository.
>
>If the backup was made while the repository was in use for
>other backups, it may be in a logically inconsistent state from
>the RMAN perspective.
>
>Kind of like backing up OID.
>
>Could be that I'm wrong on this, but I don't have time to test
>it and come up with a definitive answer.
>
>Jared
>
>
>
>
>
>"Arup Nanda" <[EMAIL PROTECTED]>
>Sent by: [EMAIL PROTECTED]
> 01/09/2003 01:09 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
> cc:
> Subject: Re: RE : RMAN Repository
>
>
>Jared,
>
>I do. Actually, I back up the "other" master in the multi-master setup,
in
>order to reduce load on the main database. But now that you have asked
the
>question, I am beginning to wonder why I ever thought of that. Restoring
>will not restore the untransmitted transactions (it's asynch
replication);
>so I will lose data and at the same time a little load on the main RMAN
>repository is not a bad idea either. Hmm...may be I'll switch to the main
>database for hot backup.
>
>The reason for hot backup is quite simple - it's easy to throw in another
>database into the hot backup system, rather than figure out a quiet
period
>for cold backup when no other databases are being backed up using RMAN.
>
>HTH
>
>Arup
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Thursday, January 09, 2003 3:30 PM
>
>
> > I do a cold backup of my repository daily.
> >
> > Replication of it is not a bad idea, as Arup mentioned,
> > though I haven't tried it myself.
> >
> > Speaking of backing up the RMAN repository, does anyone
> > back them up hot?
> >
> > Seems to me that would not be a good idea.
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > "Ruth Gramolini" <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 01/09/2003 11:04 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
> > cc:
> > Subject: Re: RE : RMAN Repository
> >
> >
> > The earlly versions of rman suggested that you put a 2nd recovery
>catalog
> > in one of the databases you are using the "real" recovery catalog for.
> > Then
> > you use this to record the backups of the recovery catalog database.
I
> > never headed this advice, altho I do use a recovery catalog for all
> > production, developement, and test databases that I back up.
> >
> > Ruth
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Thursday, January 09, 2003 1:44 PM
> >
> >
> > RE: RE : RMAN Repository>If I need a database to backup a database
then
>do
> > I
> > need another database to backup the database that backed up the
original
> > database?
> >
> > Exactly my thoughts.
> >
> > Igor Neyman, OCP DBA
> > [EMAIL PROTECTED]
> >
> >
> >
> > ----- Original Message -----
> > From: Orr, Steve
> > To: Multiple recipients of list ORACLE-L
> > Sent: Thursday, January 09, 2003 1:18 PM
> > Subject: RE: RE : RMAN Repository
> >
> >
> > Yeah but do you have to pay for another Veritas NetBackup license
and
> > server to backup the catalog? If just have one database server and one
> > database license why should I have to buy another license and install
> > another 1-2GB of Oracle software on another server? The only answer I
>can
> > think of is so Larry can spend more money on yachts, planes, and cars.
> >
> > Contrary to Oracle Corporate aspirations, not all data in the
universe
> > really needs to be stored in Oracle databases, especially backup
> > information
> > about Oracle databases I want to backup. If I need a database to
backup
>a
> > database then do I need another database to backup the database that
> > backed
> > up the original database? ;-) Seems the simple solution to this
>silliness
> > is
> > just to remove the requirement of having a database to backup a
>database.
> >
> >
> >
> > Steve Orr
> >
> >
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, January 09, 2003 10:50 AM
> > To: [EMAIL PROTECTED]
> > Cc: Orr, Steve
> > Subject: RE: RE : RMAN Repository
> > Importance: High
> >
> >
> >
> > > 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.
> >
> > Why silly?
> >
> > It isn't any more silly than making a separate backup of the Veritas
> > Netbackup catalog.
> >
> > It's just a different level of abstraction.
> >
> > Jared
> >
> >
> >
> > "Orr, Steve" <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 01/09/2003 08:45 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc:
> > Subject: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > 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" <[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: Ruth Gramolini
> > 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).
> >
>--
>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).
>
>
>
>
>--
>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).
_________________________________________________________________
The new MSN 8 is here: Try it free* for 2 months
http://join.msn.com/?page=dept/dialup
--
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).
--
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).
