Hello Experts
I have a RAC environment which I perform adhoc hot-backups using RMAN, this database also generates high amount of archive logs
I use the following to perform Hot-backups
RMAN> backup as compressed backupset database format '<path>/rman_%t_s%s_s%p.bkp' TAG 'DB_BKP' include current controlfile plus archivelog '<path>/rman_%t_s%s_s%p.arc' TAG 'ARC_BKP';
The problem is, all the archives which are not backed up before are now being backed up, which increases the backup duration and storage required for the backup
My goal is to backup only the set of archives which are needed for the consistent hot-backup
One way which I could think of, is to perform the backup in below order
1. Backup only Database
2. Find the SCN range needed for recovery
"RESTORE DATABASE PREVIEW" which indicates the recovery SCN and the SCN to clear fuzziness
3. Backup the set of archive logs using "FROM SCN" and "UNTIL SCN"
Are there any other methods to backup only the required set of archivelogs for a consistent Hot-Backup ? It would also be better if this process can somehow be automated to avoid manual intervention
Thanks,
Kaushik