Two Questions.

[joe_91]

Team:

I have two questions.

1. make_tape_recovery -x inc_entire=vg00
OR
fbackup -f /dev/rmt/0m -0 -i /
(how do i get an email with the results to joeb@msn.com)

2. We have some raw slices created for oracle. Since we backup only filesystems(with fbackup) how are these raw slices backed up? what would be the plan for those since they are not cooked?

Thanks

Joe.

[Patrick Wallek]

1) It depends on what you want to accomplish. The make_tape_recovery will give you a bootable tape you can use in case your system crashes and the VG00 disks are not recoverable.

The fbackup will give you EVERYTHING under /. This is good for general backups.

To get e-mail sent to you:

make_tape_recovery -I -a /dev/rmt/?mn -v -x inc_entire=vg00 2>&1 | mailx -s "make_tape_recovery output" joeb@msn.com

2) You would have to look into something like Oracle's RMAN feature.

[joe_91]

So the oracle's backup would not be the SA responsibility?

Thanks

Joe

[Patrick Wallek]

All backups are ultimately the Sys Admin's responsibility, at least in my opinion.

The SAs and the DBAs need to work together to make sure the Oracle data is backed up appropriately.

[Mic V.]

Sorry, this is not really on topic for the original question, but I feel so strongly about this that I wanted to support you:

Database backups were never the responsibility of the DBAs at our site. The sysadmins would consult with the DBAs on choice of methodology, come to an negotiated and documented agreement, then implement the backups. Implementation included not just error correction but also instructing Operations on how to respond to issues and writing documentation.

The DBAs don't have a wide enough view to handle the task, IMO -- don't know Operations schedule and abilities, don't have access to all system resources, aren't involved in ALL backup scheduling (only database backups), don't know what *else* the sysadmins are doing and their conventions, etc. I know there are sites where DBAs basically do any sysadmin task they want, but I don't find it makes a good setup. Fewer cooks in the kitchen = better environments.

Mic

[Ranjith_5]

Hi Joe,

I think you have an Oracle RAC. Normally raw devices are created when you dont have a cluster filesystem licence and you want to implement RAC.

Now coming to the point ..

Veritas netbackup has got the option to take backup of raw devices.

RMAN can be used for taking backup of online oracle database.

So if you need an online backup of the raw devices you can integrate RMAN with Veritas NBUP and proceed.

When you take a cold backup with only veritas NBUP you can take backup.

Both of DBAs and SysAdmins can work together and make the policies for backup. The implementation responsibility may be on DBA/SysAdmin depending on what role are you handling in the organisation. Some organisations have got backup specialists. In that case they only work with DBAs and bake policies. Once the policy is created its SysAdmins duty to make sure that its happening with out fail.


Have a nice day

regards,
Syam