Re: RMAN question(s)
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: JSweetser@xxxxxxxx
- Date: Tue, 28 Aug 2007 02:23:47 -0700
On 8/27/07, Sweetser, Joe <JSweetser@xxxxxxxx> 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
Other related posts:
