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: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Jeff
Lightner
Sent: Monday, July 09, 2007 7:13 AM
To: Mike Kiles; VERITAS-BU AT mailman.eng.auburn DOT 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:mikekiles AT yahoo DOT com] 
Sent: Monday, July 09, 2007 10:04 AM
To: Jeff Lightner; VERITAS-BU AT mailman.eng.auburn DOT 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 <jlightner AT water DOT com> 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: veritas-bu-bounces AT mailman.eng.auburn DOT edu
> [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu]
> On Behalf Of Mike
> Kiles
> Sent: Monday, July 09, 2007 9:19 AM
> To: VERITAS-BU AT mailman.eng.auburn DOT 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 AT mailman.eng.auburn DOT 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 AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu