09-25-2015 03:20 AM
Hi All,
Need to know while creating RMAN scripts for Netbackup do we need to create 3 separate scripts on the oracle client for every backup?
i.e Full,Incremenal and Archive
2:- Or we just create one script on Oracle client and through netbackup policy we can select any backup type i.e full,incremental,archive?
Pls help.
Solved! Go to Solution.
09-25-2015 04:06 AM
out of the box, you have to create two scripts. one for full and incremental backups and one for archive logs.
I always create three scripts, one for each because most of my customers does not have enough oracle experts.
BUT, if you now scripting, you can read the atributes that netbackup passes to thescript and create a script that will do all.
09-25-2015 06:06 AM
Our DBA uses one script for all backups, Full, Incremental, Cumulative.
Take a look at the sample scripts in <installpath>\ext\db_ext\oracle\samples\rman
09-25-2015 03:56 AM
Use Netbackup 7.6 Oracle Intelligent Policies - no need for scripting at all.
With no background in the intelegent policies, it took me no more than ½ hour before I got everything working.
Highly recommended !!!
09-25-2015 03:57 AM
Yeah Nicolai Its true :)
But environment is old where scripting is still being used :(
09-25-2015 04:04 AM
Upgrade it ...
Joke aside - what work for you. I personally would go for 3 different scripts.
Create one policies with schedules alone and no backup selection. Then 2 or 3 policies with a backup selection of the script you want to use.
Incremental backup can take the same time as a full backup, so consider if needed.
09-25-2015 04:06 AM
out of the box, you have to create two scripts. one for full and incremental backups and one for archive logs.
I always create three scripts, one for each because most of my customers does not have enough oracle experts.
BUT, if you now scripting, you can read the atributes that netbackup passes to thescript and create a script that will do all.
09-25-2015 04:10 AM
So is it mentioned somewhere in the script whether this oracle script is for full, Incremental or Archive?
09-25-2015 04:19 AM
if you are referring to the netbackup sample scripts, it is in the file name.
inside, the difernece is in the rman commands
09-25-2015 06:06 AM
Our DBA uses one script for all backups, Full, Incremental, Cumulative.
Take a look at the sample scripts in <installpath>\ext\db_ext\oracle\samples\rman