RE: backup up archivelogs
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 May 2005 15:10:24 -0400
Thanks Tom,
I believe I will try writing to another destination. I like the fact
that they can be written to an optional destination through nfs so that
if I have to restore/recovery - I bring the database up their first then
apply archived logs on the server I plan to recover to. I might do the
tape backup as well. I just think that multiplexing the archivelogs
means that the possibility exists that I loose 0 archive logs and that
they are written immediately to my DR site.=20
-----Original Message-----
From: Mercadante, Thomas F (LABOR)
[mailto:Thomas.Mercadante@xxxxxxxxxxxxxxxxx]=20
Sent: Thursday, May 19, 2005 3:08 PM
To: Stankus, Paula G; oracle-l@xxxxxxxxxxxxx
Subject: RE: backup up archivelogs
Paula,
If you are really worried about this, then take the simplest approach
possible.
If you know that you normally generate 10 archivelog files a day, then
simply back them up to tape, say, every 3 hours. Or 2 hours. Pick a
time frame that you are comfortable with.
At one place I worked at, we ran a job every 15 minutes that looked at
the archivelog directory. If, say, 5 files were there, we would back
them up and remove them.
With either approach, you can at least tell management that you are
doing *something* about it.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ron Rogers
Sent: Tuesday, May 17, 2005 9:42 AM
To: Paula_Stankus@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
onkarnath.tiwary@xxxxxxxxx; rgramolini@xxxxxxxxxxxxxxx
Subject: RE: backup up archivelogs
Paula,
That is a valid concern if you loose the archive log destination. How =
=3D
about setting up another destination on a different server or nfs
mounted =3D point.=3D20 Ron
>>> <Paula_Stankus@xxxxxxxxxxxxxxx> 05/17/05 9:01 AM >>>
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. =3D3D20
Anyone doing this and their thoughts on gotchas/caveats/best practices?
Thanks,
Paula
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 33017928) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D33017928&m=3D6c76=
38c4c
94c
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D33017928&m=3D6c76=
38c4c
94c
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D33017928&m=3D6c76=
38c4c
94c
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS
--
//www.freelists.org/webpage/oracle-l
Other related posts:
