Veritas-bu

[Veritas-bu] I need some additional help to backup oracle.

2006-11-22 14:25:04
Subject: [Veritas-bu] I need some additional help to backup oracle.
From: krzys at perfekt.net (Krzys)
Date: Wed, 22 Nov 2006 14:25:04 -0500 (EST)
You guys are so much more helpfull than any other place... even with symantec 
support I dont get that much support as from you guys, but anyway I have 
netbackup and one of the backup clients is running oracle. In my previous job 
DBA's were doing cold/hot backups and they just dumped files to directories 
that 
I then backed up, in this job culture I guess is sligtly different so DBA's 
told 
me that this is my job to do backups... So anyway for the cold backup they 
provided me with stop script to stop oracle databases (I know its not to good 
and it causes all sorts of problems if database would not came back etc) But 
despite those aspects what would I need to do to acomplish this task of backing 
up system with oracle down...

Here are the scripts:
- stop all databases
/home/oracle/bin/stop_all_db.sh

and

- start all databases
/home/oracle/bin/start_all_db.sh

They are typically run as oracle user.

I am a bit confused by netbackup (I used legato before and also did not have to 
do actual oracle backups) and I do not clearly understand what exactly I need 
to 
modify to bring those databases down. Can I also change user so that those 
scripts woul dbe run as oracle? How about when backups are done? which script I 
need to modify to bring them up?

Thanks guys once again for all your help....

Chris