Oops. Yep. Oracle 8 doesn't have the "alter database begin backup" command. (Been a while since I've seen an Oracle 8 database.)
You'll have to get a list of tablespaces and put each of them in backup mode. I think the command below (which I typed from the same bad memory) should give you a list of tablespaces. # su - oracle $ svrmgrl <<EOF >/tmp/tablespaces.txt > connect internal > select name from v$tablespace > EOF --- W. Curtis Preston Backup Blog @ www.backupcentral.com VP Data Protection, GlassHouse Technologies -----Original Message----- From: Mike Kiles [mailto:[EMAIL PROTECTED] Sent: Monday, July 09, 2007 2:54 PM To: Curtis Preston; Jeff Lightner; VERITAS-BU@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4 One question, can I put the whole database in backup mode or I have to put each tablespace in backup mode. I read it somewhere that for Oracle8 and before, you can not put the whole database in backup mode. TIA --- Curtis Preston <[EMAIL PROTECTED]> wrote: > Yeah, I think we're all saying the same thing. I'll > just comment on a > couple of your comments about hot backups. > > 1. I'll say I'm a fan of RMAN. The value of it > significantly outweighs > it's cost. True incremental backups (10g+) and > two-command > restore/recover are enough. But RMAN has come a > long way. RMAN is 8 is > nowhere near as good as it is in 9, and even farther > from RMAN in 10g. > > 2. Recovering from hot backups requires a single > command "recover > database." All you need is for the archivelogs that > span the time of > the backup to be in the right place, or tell Oracle > where they are. > It's the same command that's used to roll last > night's cold backup > forward to the point of failure. With a cold backup > it's optional; with > a hot backup it's required. If you don't want to > roll to current point > in time, you have to add an "until" statement, like > "until cancel" or > "until <time>." It's really not that big of a deal. > > 3. Under normal conditions, the control file's got > nothing to do with > the difficulty of recovering from a hot backup. The > control file simply > must be more recent than the backup, but that's the > same with a cold > backup. Now, if you lost ALL control files > (something that should never > happen if you're multiplexing/mirroring them) then > yes, you'd have to do > another step if you're recovering from a hot backup. > > 4. The performance difference (and space difference) > while in backup > mode is negligible. It's probably one of the most > misquoted and > misunderstood things in Oracle. On the times I've > measure it, the > difference was less than 3%, and that was only under > extreme load. > > I hope this helps our mutual friend. ;) > > --- > W. Curtis Preston > Backup Blog @ www.backupcentral.com > VP Data Protection, GlassHouse Technologies > > -----Original Message----- > From: Jeff Lightner [mailto:[EMAIL PROTECTED] > Sent: Monday, July 09, 2007 11:21 AM > To: Curtis Preston; Mike Kiles; > VERITAS-BU@mailman.eng.auburn.edu > Subject: RE: [Veritas-bu] Oracle 8 Backup - NBU6.0 > MP4 > > It appears you misread something. If you're doing > RMAN you don't do it > cold at all. I said he had to use RMAN because he > said he couldn't > take the DB down (which he would have to do for a > cold backup). > Earlier I'd noted that one could do a hot backup but > noted that hot > backups are harder to "recover" (not "restore"). > This is for reasons > DBAs could tell you but I couldn't - something about > the control file. > I guess he could do hot backup mode instead if he > can't shut it down but > there is additional work for restore as well as > additional logging it > does while in that mode and the performance impact > of that logging and > later commits to DB. I've never measured these and > given that he's > running Oracle 8 stair-stepping might make hot > backup preferable to > RMAN. > > In summary I was discussing 3 different things: > > Cold backup > DB down - NBU "standard" backup of the filesystem(s) > or raw device(s) > containing DB spaces. > > Hot backup > DB in "hot backup mode" - NBU "standard" backup of > the filesystems(s) or > raw devices(s). > > RMAN backup > DB up - RMAN feeding the backup to NBU with Oracle > add on using RMAN > repository and RMAN/NBU-ORACLE scripts. > > For the record we do the BCV copy of hot backup > every day except Sunday > when we do a BCV copy of cold backup. When we > write to tape we're > actually doing so from the BCV copy. This is for > our 4 TB Production > backup. We have a smaller 300 GB Production that is > backed up using > RMAN. > > Support is problematical however - does Oracle > actually support 8 > anymore with RMAN? Will the newer NBU versions > support an older RMAN if > that is required for Oracle 8? > > I haven't written a book about it so I'm willing to > assume you know more > about it than I do. :-) > > -----Original Message----- > From: Curtis Preston > [mailto:[EMAIL PROTECTED] > Sent: Monday, July 09, 2007 2:04 PM > To: Jeff Lightner; Mike Kiles; > VERITAS-BU@mailman.eng.auburn.edu > Subject: RE: [Veritas-bu] Oracle 8 Backup - NBU6.0 > MP4 > > Jeff, in your previous post, you mentioned backing > up the database hot > using the commands he mentioned. Why are you now > saying he has to do it > cold and has to use RMAN? > > What he's proposing is fine. It's not as good as > RMAN (by far), but he > definitely doesn't have to buy the agent just to > back up Oracle. The > database must be in archivelog mode for it to work, > but he specified > that he's doing that. > > 1. Login as oracle user > 2. connect internal (or as sysdba) > 3. alter database begin backup > 4. Select * from sys.dba_data_files > (that will give you a complete list of data files > to back up) > 4. Back up the files/filesystems found in #4 > 5. alter database end backup > 6. alter system archive log current > 7. Find out the value of LOG_ARCHIVE_DEST, where > archived redo logs are > sent > 8. Back up LOG_ARCHIVE_DEST, or at least the files > that were created > just before, during, and just after the backup > > Shameless plug: This procedure (and how to use RMAN > without buying an > agent for it) is covered in my book: > > http://www.oreilly.com/catalog/backuprecovery > > --- > W. Curtis Preston > Backup Blog @ www.backupcentral.com > VP Data Protection, GlassHouse Technologies > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > On Behalf Of Jeff > Lightner > Sent: Monday, July 09, 2007 7:13 AM > To: Mike Kiles; VERITAS-BU@mailman.eng.auburn.edu > Subject: Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 > MP4 > > If you can't shut it down you'll need to use RMAN > and the NetBackup > Oracle add on. I can't offer a lot of guidance on > that since we do > have DBAs that created the repository it needs and > are responsible for > the scripts and cron scheduling - we only created > the policy and the > "schedules" (full, incremental etc...) within that > which they call from > the scripts. There are sample RMAN scripts with > the NBU Oracle stuff. > > -----Original Message----- > From: Mike Kiles [mailto:[EMAIL PROTECTED] > Sent: Monday, July 09, 2007 10:04 AM > To: Jeff Lightner; VERITAS-BU@mailman.eng.auburn.edu > Subject: RE: [Veritas-bu] Oracle 8 Backup - NBU6.0 > MP4 > > Database is not big it is only about 200GB, but we > can > not shut it down for backups. We dont have a DBA > here, > only some developers who can assist me, but they are > not very familiar with backups. > Thx > --- Jeff Lightner <[EMAIL PROTECTED]> wrote: > > > If you aren't going to set up RMAN you need to do > > backups of the > > filesystem(s) or raw device(s) where the > dataspaces > > are defined. The > > best way to do this is with the database > completely > > down. This is > > called a "cold backup". You can also do a "hot > > backup" by putting the > > database in "hot backup" mode but that requires > more > > effort to get going > > after restore. How large is your DB? For really > > large ones having it > > down long enough for a cold backup or even in hot > > backup mode isn't > > really a good thing. Most shops with really > large > > DBs do a BCV/snap of > > the database then do the backup to tape from the > > that BCV/snap copy > > after splitting and restarting the primary DB. > > > > RMAN requires a separate Oracle repository. Do > you > > not have Oracle DBAs > > to deal with that part of it? > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > On Behalf Of Mike > > Kiles > > Sent: Monday, July 09, 2007 9:19 AM > > To: VERITAS-BU@mailman.eng.auburn.edu > > Subject: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4 > > > > Good Day > > > > I have asked to a full backup of our oracle 8 > > database > > which is running in archive log mode. RMAN is not > > set > > up and I was told to put the database in backup > > mode. > > I am not a DBA and would appericiate your help if > > someone can tell me the exact commands to run on > the > > database server (Tru64) prior to me starting the > > backup and the commands to run after backup is > > finished. > > > > Here is what I was thinking of running prior to > > starting the backup: > > - Login as oracle user > > - connect internal > > - alter database begin backup > > > > After the backup is finished > > - Login as oracle user > > - connect internal > > - alter database end backup > > > > I read some dicussions about switching log files > and > > also about backing up control files, but I > couldnot > > find out the commands to accomplish thes and where > > to > > put them. > > > > Anything else that I may have missed? > > > > Thanks > > > > MK > > > > > > > > > ________________________________________________________________________ > > ____________ > > Be a better Globetrotter. Get better travel > answers > > from someone who > > knows. Yahoo! Answers - Check it out. > > > http://answers.yahoo.com/dir/?link=list&sid=396545469 > > _______________________________________________ > > Veritas-bu maillist - > > Veritas-bu@mailman.eng.auburn.edu > > > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu > > > > > > > ________________________________________________________________________ > ____________ > Luggage? GPS? Comic books? > Check out fitting gifts for grads at Yahoo! Search > http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz > > _______________________________________________ > Veritas-bu maillist - > Veritas-bu@mailman.eng.auburn.edu > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu > > _______________________________________________ > Veritas-bu maillist - > Veritas-bu@mailman.eng.auburn.edu > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu > ________________________________________________________________________ ____________ 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu