Thanks Curtis. --- Curtis Preston <[EMAIL PROTECTED]> wrote: > 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 >
____________________________________________________________________________________ Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. http://mobile.yahoo.com/go?refer=1GNXIC _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu