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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: backup up archivelogs

RE: backup up archivelogs

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Fri, 20 May 2005 18:51:09 +0200
Message-Id: <1116607868.4881.11.camel@dbalert199.dbalert.nl>


Which is exactly the way Oracle Data Guard 3.x for 8.1.7 EE works, almost completely ksh-script based. There even is an alert-file parser active. It can add datafiles to the standby database automatically.... If you are on 9i or higher, you can use tha archive_lag_target parameter to perform the logswitch automatically. Saves a dbms_job or cron script, thus reducing the chance of a failure there.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Thu, 2005-05-19 at 21:16, Khemmanivanh, Somckit wrote:

> Speaking of which....
>
> We actually backup our archivelogs "on demand" to our DR site. On demand
> means as soon are the log is fully archived to the archive directory. We
> do this by reading the alert log, this tells us when the logfile has
> been archived. We then identify the file and back it up to tape at the
> DR site (the script also verifies the backup to tape was successful).=20
>
> This give us instant up to date logs at the DR site without the need for
> any remote mirroring technology.
>
> If we so chose to, we also schedule routine archivelog switches to
> minimize the exposure window...
>
> Thanks!=20
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 20 2005 - 12:55:54 CDT

Original text of this message

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