Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copying archivelogs every ten minutes
On Mar 16, 1:02 pm, "chris b" <chris.br..._at_providenthims.co.uk> wrote:
> Oracle 10g enterprise rac on windows using ASM
>
> I am looking to set up a scheduled job that loads archivelog copies
> into a directory every ten minutes.
> , the contents of this directory will then be shipped to another
> server for disaster recovery purposes
>
> Is there a way I can do this that means that I capture all logs
> without duplicating , so that I end up with a directory that has all
> archivelogs produced.
>
> I was thinking of the backup as copy archivelog since syntax
>
> regards
> Chris B
Rather than implementing this Mickey Mouse method, why don't you set
up a standby database?
Your 'procedure' will fail sooner or later, and you will have no
control over it.
If you don't use automatic recovery on the Standby database, you have
*exactly* what you describe above.
-- Sybrand Bakker Senior Oracle DBAReceived on Fri Mar 16 2007 - 07:17:32 CDT