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: <Paula_Stankus_at_doh.state.fl.us>
Date: Tue, 17 May 2005 09:45:47 -0400
Message-ID: <E518A02B320C8D4E97D99A8C546480210C3EB149@dohsmailhq01.doh.ad.state.fl.us>


My one concern is this - I know that I can setup optional archive destinations this way which means to me if there is a problem with the destination - everything still works. I don't have my primary database hang waiting to write out online redo logs. However, what if the optional destination is available but I/O is slower? Will that slow anything down?

Thanks,
Paula

-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org]=20 Sent: Tuesday, May 17, 2005 9:42 AM
To: Stankus, Paula G; oracle-l_at_freelists.org; onkarnath.tiwary_at_gmail.com; rgramolini_at_tax.state.vt.us Subject: RE: backup up archivelogs

Paula,
 That is a valid concern if you loose the archive log destination. How about setting up another destination on a different server or nfs mounted point.=20
Ron

>>> <Paula_Stankus_at_doh.state.fl.us> 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. =3D20

Anyone doing this and their thoughts on gotchas/caveats/best practices?

Thanks,
Paula

--
http://www.freelists.org/webpage/oracle-l



BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 32665082) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D32665082&m=3Dfacd=
96262
138
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D32665082&m=3Dfacd=
96262
138
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D32665082&m=3Dfacd=
96262
138
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 17 2005 - 09:50:25 CDT

Original text of this message

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