Thanks Jeff
--- Jeff Lightner <jlightner AT water DOT com> wrote:

> 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
> 




 
____________________________________________________________________________________
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=list&sid=396546091
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu