Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Copying archivelogs every ten minutes

Re: Copying archivelogs every ten minutes

From: sybrandb <sybrandb_at_gmail.com>
Date: 16 Mar 2007 05:17:32 -0700
Message-ID: <1174047452.222083.25330@o5g2000hsb.googlegroups.com>


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 DBA
Received on Fri Mar 16 2007 - 07:17:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US