Hi Ken,
The reason being is that sometimes we might need to take a copy of a recent
level 0 backup and archive it and we will want to be able to restore and
recover at some future time when the archive logs are no longer on disk.
Kenneth Fowler <kenneth.r.fowler@xxxxxxxxx> hat am 5. Januar 2016 um 16:33
geschrieben:
Hi All,
We currently have a backup script that executes RMAN level 0 backups once
per week and level 1 backups every other day. The code is generated
dynamically via a shell script and is then executed. Here is a recent
example of a level 0 backup that was executed...
sql 'alter system checkpoint';
backup as compressed backupset incremental level 0
format
'/opt/oracle/backup/bioocld1/sets/2016-01-02_211929_lev0/2016-01-02_211929_lev0_%s_%p'
database;
alter system switch logfile;
alter database backup controlfile to
'/opt/oracle/backup/bioocld1/sets/2016-01-02_211929_lev0/2016-01-02_211929_ctl_bk';
Archive log backups are not currently included and are backed up via a
separate process however I want to change this slightly. I would like the
level 0 backup sets to also include the minimal set of archive logs needed to
recover the backup. The reason being is that sometimes we might need
to take a copy of a recent level 0 backup and archive it and we will want to
be able to restore and recover at some future time when the archive
logs are no longer on disk.
I guess I can query v$log to get the current archive log sequence before the
backup starts and use "backup archivelog from sequence nnn" after the
database backup but wondering if there is already some RMAN
functionality/syntax that I can use to achieve the same?
Thanks,
Ken.