Use Veritas Netbackup to do database hotbackup

Posted on 2004-09-09
Last Modified: 2008-02-01

I am figuring how to use our Veritas Netbackup 4.5 to do hot database backup. The key point is that our Veritas software doesn't contain the module that supports hot backup, we have to do a cold backup by using a script to shut down the database, use bpbackup command to backup files and then start the database. Now for the hotbackup, I probably have to use the media manager to write to the tapes device, our backup media. I am new to Veritas software. Can anyone give me some idea about how to get started, how could I write database files into a tape device managed by Veritas?

Question by:ebi168
LVL 55

Assisted Solution

andyalder earned 400 total points
ID: 12024655
What is the database, DB2, Oracle, SQL etc? If there isn't an agent available for it maybe the database has its own internal backup prog that can back itself up to disk then let NetBackup backup the file it creates.

Assisted Solution

gingerjock earned 50 total points
ID: 12026646
Just to echo what andyalder said regarding hot database backups. Without any add-on agent for NetBackup you will be unable to perform a good backup of any database. However if the database has an on-line backup facility, like RMAN in Oracle, then simply RMAN the database to an area and then back the area up when RMAN has finished. This will all but ensure that your backups are good.

If you are using Solaris then you may want to investigate the command fssnap, which allows you to backup live, changing files. Im not sure if it will work with database files as it has an issue with any files it cannot write-lock while performing its backup.

If you have the luxury of a mirrored database volume then simply drop the mirror and back it up. Or if you have a spare area and no mirroring look at something like rsync to copy the database to another area and then simply stop the sync while you backup. Very messy but hey if you aint got the agents for NBU then your struggling.

Author Comment

ID: 12028164
I heard about hot backup to a folder first and then use veritas to automatically backup those files. But I still want to explore the way of writting directly to the tape.

I don't quite familiar with the way of fssnap and drop, backup a mirror. What I do know is that when I read the veritas media manager admin guide, it says external access to media manager controlled devices must use tpreq and tpunmount to have access to an UP drive under ltid control. ltid is the device daemon that restrict access to media manager controlled drives that are in an UP state. It looks like we can use unix os copy commands, but we still can't totally by pass veritas.

So I have to use tpreq first and then use tar, dd or cp to write to the tape. I know we can write from disk to tape use tar. Can we use dd and cp?

LVL 55

Accepted Solution

andyalder earned 400 total points
ID: 12028917
You can use anything you like once you have told media manager to put the tape in the library and give you control of the drive but it will just be a bunch of foreign tapes to Veritas, it won't know what's on them so the contents won't be cataloged.

Assisted Solution

jamespung earned 50 total points
ID: 12030731
andyalder is correct, if you don't have database agents installed and licensed, you won't be able to do hot backups to tape via netbackup.  You'd have to do a backup to a file using the native database backup utility, then backup the file via netbackup.

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now