Re: Hot back up problem.

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 20 Dec 2000 11:51:47 -0000
Message-ID: <91q6gl$g8h$1@soap.pipex.net>

comments embedded

"Chris Lee" <clee_at_innocent.com> wrote in message news:3A3F6B9E.6CEBB30E_at_innocent.com...

Your backup script appears to have an error in it, leading to the problem described by David

after backing up the tablespaces your script reads
> REM Stop the archiving process.
> archive log stop
> exit
> EOF1
>
> # Back up archive log files.
> ArchFiles=`cd $ARCH_DIR; ls ./*.arc`;
>
> # Restart archiving process.
> svrmgrl <<EOF2
> connect internal/$PASSWD
> archive log start;
> exit
> EOF2
I would alter this to read

> REM Stop the archiving process.

archive log all
> archive log stop
> exit
> EOF1
this ensures that all online redo logs are archived before stopping the archiver.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Wed Dec 20 2000 - 05:51:47 CST