05-01-2007 05:35 AM
We want to implement a Veritas Solution using Netbackup 6.0 MP4 with EVA 3000, and Advance Client. There are numerous documents saying that the EVA will not work with Advance Client and there are some that say the EVA will work with Advance Client.
Will using RMAN be a hindering process. I want to backup our oracle DB using netbackup and RMAN and i would like to be able to restore this DB onto various other test databases. The idea is to take our production database backups and restore them wherever we like for testing purposes.
05-02-2007 03:21 AM
Not knowing how Netbackup works (we use EMC Networker), here is what we do with a production oracle instance an a Eva5000.
At midnight, shutdown oracle, then, using SSSU, create a clone on the san (to a FATA disk group), startup Oracle, present the Clone_db to the server and we are done. Then, any test instance that needs a refresh of production, we simply run a clone script to copy db files from the clone_db to the test instance.
As far as backup to tape, it can be done anytime, until the entire process runs again (23 hours later).
I am not too familiar with RMAN but I know there is a way to;
Run Rman to a seperate San device, backup to tape, use rman to refresh test instances, then, 23 hours later, delete rman backup files, and then run the process again.
Hope this helps.
05-02-2007 05:06 AM
05-02-2007 07:06 AM
"Would you have an idea if RMAN can be triggered to start up a backup with a trigger file rather than a timed backup?"
On one of production oracle instances, we do start RMAN> backup database plus archivelogs;
via a scheduled file. Does/Can RMAN kick off a file to start other scripts?, that I would not know.
I have attached 3 files. They go, in sequence.
2)daily_db_backup, which part of it is to submit the third file;
I have attached a fourth file to show you our scheduling and parameters.