Re: RMAN question(s)

On 8/27/07, Sweetser, Joe <JSweetser_at_icat.com> wrote:
>
> My question is what do people around here do? Backup database and
> backup archivelog? Backup database...plus archivelog? I realize this
> is somewhat "nuancy" but, personally, I like the idea of at least being
> able to get the database back (and opened) with a single night's backup
> that is copied to tape. Opinions/thoughts/experiences?
>
>

My preferred method.

Archive logs are backed up twice before being deleted.

        BACKUP $BACKUP_TYPE FORMAT '%d_T%T_db_s%s_p%p_t%t' DATABASE;
        SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';

        BACKUP FORMAT '%d_T%T_arch_s%s_p%p_t%t' ARCHIVELOG ALL NOT BACKED UP
2 TIMES;
        DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE sbt;
        BACKUP FORMAT '%d_T%T_ctl_s%s_p%p_t%t' CURRENT CONTROLFILE;

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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