06-17-2020 05:40 AM
Hello All,
We backup Oracle RMAN backups via scripts in NBU 8.0. Recently someone mentioned that the best way to backup would be use a RMAN catalog instead of scripts. We have been using scripts for RMAN backups in NBU for as long as I can remember. Can someone please explain what is catalog based backup (is it the intelligent policy). Will there be a benefit to move away from scripts to catalog based and how big of an effort is the change typically.
NBU 8.0 on Windows
Unix Oracle.
Thank you
06-17-2020 06:32 AM - edited 06-17-2020 06:33 AM
The recovery catalog contains metadata about RMAN operations for each registered target database. When RMAN is connected to a recovery catalog, RMAN obtains its metadata exclusively from the catalog.
https://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmcatdb.htm#CHDFCIFF
Your question should be to DBA rather than Backup Admin about how to manage RMAN script & RMAN Catalog.
NetBackup intermediate to perform the RMAN backups, NetBackup has is its own Catalog & stores information about the Backup that is triggered by RMAN script or intelligence policy. NetBackup retains the backup as defined in the script by using NetBackup policy schedule. RMAN defines & executes the backup of Oracle DB and NetBackup writes the backup. RMAN cannot manage retention (or expiration) or storage of the backup, that's done by Netbackup.
06-17-2020 06:41 AM
@Tape_Archived Thank you for your reply. We backup Oracle using scripts, I'm familiar with this method.However I'm curious if the catalog method is possible with NetBackup and if so what are benefits over script based, if any. If there's any Netbackup article,appreciate if you can please share the link.
Thank You.
06-17-2020 07:24 AM - edited 06-17-2020 07:25 AM
I think there is a confusion here.
When performing RMAN based backups (either via scripts, OIP or manual), the meta data can either be stored in the database control file (bad if everything is gone) or in a RMAN catalog. A rman catalog is a seperate database (on a seperate host if possible) contaning the information of what backup has been made.
Best regards
Nicolai
06-17-2020 08:06 AM - edited 06-17-2020 08:08 AM
06-17-2020 09:32 AM
I have heard of stored scripts within the RMAN catalog.
One of the advantages is that no passwords need to be stored in plain text in 'regular scripts'.
This URL explains about creating stored scripts:
https://web.stanford.edu/dept/itss/docs/oracle/10gR2/backup.102/b14191/rcmcatdb005.htm
I cannot see from this URL how these scripts are automated or scheduled.
Can your dba tell us?
06-18-2020 12:55 AM
I think there is a example here:
https://community.oracle.com/blogs/felipedba/2015/05/04/usinf-rman-stored-scripts