Re: RMAN level 0 hot backup and archive logs

I did look at that. The problem is that "plus archivelog" in my environment will give me a lot more logs than I need and I want to keep the backup set as small as possible.

I am thinking that I will need to use either of "backup archivelog from sequence" or "backup archivelog from time" to give me just the logs I need for recovery.

Thanks,
Ken.

On Tue, Jan 5, 2016 at 10:54 AM, Deas, Scott <Scott.Deas_at_lfg.com> wrote:

> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Kenneth Fowler
> *Sent:* Tuesday, January 05, 2016 10:34 AM
> *To:* Oracle-L_at_FreeLists.org
> *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.**
>

--
http://www.freelists.org/webpage/oracle-l