RE: backup up archivelogs
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <Paula_Stankus@xxxxxxxxxxxxxxx>, <rgramolini@xxxxxxxxxxxxxxx>, <onkarnath.tiwary@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 May 2005 09:23:00 -0400
I am thinking I could poll v$archived_log every X minutes then based on
finding a new record I could trigger a mail to my backup server. My
backup server could have a crontab that looks for these mails
periodically then when it finds it backs up the archive destination and
copies over the files. I am thinking it might be better to use the
optional archive destination and through SQL*Net write to the box most
likely to be recovered to.=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Tuesday, May 17, 2005 9:01 AM
To: rgramolini@xxxxxxxxxxxxxxx; onkarnath.tiwary@xxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: backup up archivelogs
We have redo members mirrored on multiple file systems. We write the
redos to an archive log. We backup the database in full along with
archivelogs each night.
The problem is that if the entire box goes down or we loose the RAID for
archives we would only be able to restore/recover to the previous night.
I am considering backing up archivelogs to tape immediately as they are
filled up. =3D20
Anyone doing this and their thoughts on gotchas/caveats/best practices?
Thanks,
Paula
--
//www.freelists.org/webpage/oracle-l
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 32659490) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D32659490&m=3Dec1a=
9fc6e
e89
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D32659490&m=3Dec1a=
9fc6e
e89
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D32659490&m=3Dec1a=
9fc6e
e89
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS
--
//www.freelists.org/webpage/oracle-l
Other related posts:
