Re: Hot backups : Catching the last Archived redo log at the end of the backup cycle.

alter system switch logfile;
(or alter database ... I'm not sure of that!) After that you should wait until the file is archived (see view v$log)

HTH

--
bye ali

Rob Forster wrote:



> After one completes backing up their last tablespace, how can we be sure

> that when copying the last redo log we do not catch ARCH when its in the

> middle of archiving the last redo log?

>

> alter tablespace begin backup;

> ! cp  etc.

> alter tablespace end backup;

> alter system switch logfile; --  arch starts archiving the latest redo log

> that was forced by this command

> ! cp ...

> -- are we going to be copying an incomplete archived redo log here?

>

> TIA,

> Rob.