Re: Take the archives during the backup

From: joel garry <joel-garry_at_home.com>
Date: Mon, 30 Aug 2010 08:41:31 -0700 (PDT)
Message-ID: <f395fb40-4943-4eea-bba5-6832c0d4d332_at_m17g2000prl.googlegroups.com>

On Aug 30, 7:41 am, Vinni <hea..._at_gmail.com> wrote:
> On Aug 29, 11:51 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
>
>
>
> > heald:
>
> > > Using RMAN the most practical and safest approach to me would be to
> > > backup all the archives that have not been backed up, then backup the
> > > database plus the archives logs and then you would just copy the files
> > > from the time of the second backup which you could get from the
> > > listing the backups to know which files to copy and you still have
> > > your archives backed up from before.
>
> > > Something like:
>
> > > SQL 'ALTER SYSTEM CHECKPOINT'';
> > > SQL 'ALTER SYSTEM SWITCH LOGFILE'';
> > > backup archivelog all;
> > > SQL 'ALTER SYSTEM CHECKPOINT'';
> > > backup database plus archivelog;
>
> > If you go down this path you probably want to do the backup database
> > then switch archivelogs then backup the archivelogs.
>
> > You want to make sure you have an archivelog after the backup in other
> > words.
>
> RMAN automatically switches them out making sure you have all the logs
> used during the backup(well its supposed to), however i've been using
> this particular backup script below for years, tested it countless
> times and had to depend on backups taken with it on several occasions
> and I put the archive log backup separately for some reason which may
> be the same reason your talking about, despite oracle saying the plus
> archivelog option should work.
>
> :
>
> connect target /
> run
> {
> crosscheck archivelog all;
> crosscheck backup;
> crosscheck copy;
> backup database;
> backup archivelog all not backed up 2 times;
> restore database validate;
> delete noprompt archivelog all completed before 'SYSDATE -7';
> delete noprompt obsolete;
> sql "create pfile from spfile";
> sql "alter database backup controlfile to trace";
>
> }
>
> If that's the case i'de change the original script to I posted to this
> to make sure im using stuff i've tested myself for time:
>
> SQL 'ALTER SYSTEM CHECKPOINT'';
> SQL 'ALTER SYSTEM SWITCH LOGFILE'';
> backup archivelog all;
> SQL 'ALTER SYSTEM CHECKPOINT'';
> backup database;
> backup archivelog all not backed up 2 times;

Please show rman configuration changes. It can make a difference.

jg

--
_at_home.com is bogus.
http://www.signonsandiego.com/news/2010/aug/29/covario/

Received on Mon Aug 30 2010 - 10:41:31 CDT