08-22-2013 08:26 PM
hi, i have several oracle database instances that need to be backed up. These are not RAC. I would like to use netbackup to schedule both hot and archive log backups. The hot backup seems simple enough using the samples. I would like to know the proper way to backup archive logs. On some servers these archive logs need to be backed up every hour. To make things 'simple' i am thinking about doing hot backups every night then the AL backups throughout the day. Please share some insight on how to do this the most efficient and effective way.
thanks!
08-23-2013 05:49 AM
Backup archive logs the same way as database, using RMAN ...
# db script
SEND 'NB_ORA_CLIENT=db_serv, NB_ORA_SERV=master_srv;
BACKUP DATABASE;
# log script
SEND 'NB_ORA_CLIENT=db_serv, NB_ORA_SERV=master_srv;
BACKUP ARCHIVELOG ALL ;
Create one Policy for db backup, Schedule once per day. Create another Policy for log backup, Schedule every X hours.
08-23-2013 10:07 AM
Thanks, WR. so you are saying this is the hot database backup script:
# db script
SEND 'NB_ORA_CLIENT=db_serv, NB_ORA_SERV=master_srv;
BACKUP DATABASE;
and this is the archivelog script?
# log script
SEND 'NB_ORA_CLIENT=db_serv, NB_ORA_SERV=master_srv;
BACKUP ARCHIVELOG ALL ;
nothing else is needed at all other than changing db_serv and master_srv?
keep in mind i am not a dba. is this as simple as it needs to be?
08-23-2013 11:34 AM
That is just a small part of the script. You definitely need a DBA to set up RMAN!
NetBackup role is creating the Policies, each references appropriate script as Backup Selection.