Kenneth,
Have you looked into BACKUP … PLUS ARCHIVELOG
(https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmbckba.htm#BRADV89525).
Thanks,
Scott
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Kenneth Fowler
Sent: Tuesday, January 05, 2016 10:34 AM
To: Oracle-L@xxxxxxxxxxxxx
Subject: RMAN level 0 hot backup and archive logs
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.
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged,
confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or
entity to
which it is addressed. If you are not the intended recipient of this E-mail,
you are
hereby notified that any dissemination, distribution, copying, or action taken
in
relation to the contents of and attachments to this E-mail is strictly
prohibited
and may be unlawful. If you have received this E-mail in error, please notify
the
sender immediately and permanently delete the original and any copy of this
E-mail
and any printout. Thank You.**
