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 _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu