We are using 2-node 10gR2 RAC on Windows Server. We use Symentec Netbackup 7.5 for backing up Oracle databases. We want to change the retention period of RMAN backups to 1 year. Other than changing the RMAN Backup recovery window to 365, what are the other considerations (other configuration change, other point etc) we should be aware of?
You need to use an RMAN Catalog (i.e. a database schema) because the control file may not be sufficient to hold information about backups. Nevertheless, it is a good idea to increase CONTROL_FILE_RECORD_KEEP_TIME beyond the default of 7 days (the max value is 365 days).
Hemant K Chitale
Thanks for the feedback. Currently we can't use a catalog database (maybe in future) so we have to go with using control file.
Why can't you use a catalog database?
> Other than changing the RMAN Backup recovery window to 365, what are the other considerations (other configuration change, other point etc) we should be aware of?
Use RMAN Catalog.
How to restore your database if a storage failure occurs and all files on filesystem be lost and all rman files be at MML.
RMAN need a catalog to request files from MML (this catalog can be a controlfile, rman catalog or both), so if you lost your controlfile without RMAN Catalog you need manually find desired files on MML and restore it one by one if these files are not cataloged in that controlfile restored, since Oracle does not catalog files stored at MML. RMAN catalog files only stored on disk.