Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4
2007-07-09 10:27:12
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Veritas-bu] Re: 3rd Party Support, delmar
- Re: [Veritas-bu] 3rd Party Support, Jeff Lightner
- Re: [Veritas-bu] 3rd Party Support, Curtis Preston
- [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4, Mike Kiles
- Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4, Jeff Lightner
- Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4, Mike Kiles
- Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4,
Jeff Lightner <=
- Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4, Mike Kiles
- Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4, Curtis Preston
- Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4, Jeff Lightner
- Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4, Curtis Preston
- Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4, Mike Kiles
- Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4, Curtis Preston
- Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4, Wayne T Smith
- Re: [Veritas-bu] Oracle 8 Backup - NBU6.0 MP4, Mike Kiles
|
|
|