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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> 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: [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 > === 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: [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: Robert Freeman 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).