I expect the angels probably sing when your shell scripts are running
Rachel.
:-)
RF
-----Original Message-----
Carmichael
Sent: Friday, January 10, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L
I'm not saying RMAN should not be used... I wondered why a database was
needed to store the information. It's obviously NOT needed or you
couldn't use the controlfiles for the RMAN information.
and for what it's worth, no matter how fancy I CAN write a script, I
try to write it as "plain vanilla" as possible, with lots of comments
about what I am doing at each step. I realize this sets me apart from
the norm but who wants to be normal?
- Freeman Robert - IL <FREEMANR_at_tusc.com> wrote:
> I actually think RMAN is pretty simple. First, most of the MML
> vendors offer
> a product that allows
> you to monitor the tape read/write process if you are using MML... So
> that
> allows you to do the
> monitoring thing.
>
> The problem with shell scripts are numerous. First of all, the person
> who
> wrote it may be a much
> more advanced shell scripter than you are. Once they take that cool
> DBA job
> on the international
> space station, God help you when you have to figure out their code.
> Perhaps
> you are the shell scripter
> expert, but the same problem exists, once you leave who is going to
> sit and
> figure out that cool code
> that you wrote? With RMAN, Oracle is the support for your backup and
> recovery product. Since it's an
> Oracle database to begin with it makes since to me to use their
> product.
>
> I think in 8i and particularly 9i, RMAN has become incredibly easy to
> use,
> feature rich and very
> robust. I mean, when all you really have to do to perform a hot
> backup on
> your database is to
> fire up rman and type in backup database and the whole shebang is
> taken care
> of... well, it
> just isn't going to get much easier.
>
> As for the hot backup/cold backup question about the repository....
> Are we
> talking about cold
> backups in ARCHIVELOG mode or cold cold, NOARCHIVELOG backups? I much
> prefer
> hot backups of the
> repository myself, but YMMV.
>
> 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: Friday, January 10, 2003 10:14 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Thanks for the support, Rachel. I was wondering if I was the only one
> in
> this want-simple-and-robust-RMAN camp. What you described for cold
> backups,
> I used to do for hot backups as well in the pre-RMAN days and do it
> even
> now. In fact in a site we use BrightStor backup software from CA, I
> create a
> shell script on the fly with all the sql and the backup commands and
> execute
> that. In the end, the script as well as the log files are backed up
> to the
> tape as well. In some previous site, I had the good fortune to have a
> excellent shell scripter in my team who wrote nice scripts to read
> these
> logs and report all kinds of things like last backup date, the SCN
> number of
> last backup, the scn number in the controlfile, etc., very close to
> what
> RMAN provides. And, best of all, no Oracle database to worry about.
> Why
> couldn't RMAN do that?
>
> I still stand by my leather interior tank analogy. Throw in a
> monnroof and
> heated seats, it makes it comfortable and robust but when you max out
> your
> card paying for gas or take for an "oil-change", you perhaps wonder
> "may be
> I should have a Jetta"!
>
> Arup
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, January 10, 2003 6:04 AM
>
>
> > way back when, I wrote my own set of scripts to handle backups. As
> each
> > datafile was backed up, I wrote the full path name to a text file.
> At
> > the end of the backup the text file was written to tape as well.
> >
> > As I did restores, I read the text file. then I used that file to
> let
> > me know which file I was reading from the tape and where to put it.
> I
> > wrote another text file while I was doing the restore, as each file
> was
> > successfully read and written to disk. This allowed me to restart
> the
> > restore from where I had stopped, instead of from the beginning
> again.
> >
> > Admittedly, this was for cold backups of the Oracle database, but I
> > can't see why RMAN couldn't have as easily done the same thing for
> hot
> > backups.
> >
> >
> > --- Arup Nanda <arupnanda_at_hotmail.com> wrote:
> > > 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: 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: 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_at_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: <F001.0052BE7E.20030109151943_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: 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
>
=== message truncated ===
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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: Robert Freeman
INET: robertgfreeman_at_yahoo.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 Sun Jan 19 2003 - 01:44:16 CST
