Re: Take the archives during the backup

> 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. Received on Sun Aug 29 2010 - 17:51:55 CDT