cancel
Showing results for 
Search instead for 
Did you mean: 

oracle archive log backups scheduled with netbackup

banasrs
Level 2
Certified

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!

3 REPLIES 3

Will_Restore
Level 6

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.

banasrs
Level 2
Certified

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?

Will_Restore
Level 6

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.