Re: newbe dba questions
Date: 1995/05/19
Message-ID: <D8v7Hy.ABE_at_indirect.com>#1/1
von.prahl_at_uprc.com wrote:
> i have an oracle database installed on a raid array.
> ALL the database files exist on the array, including
> the control files.
> The raid array gives me some security from media
> failure but probably not enough. the problem i have is that
> i only have two physical devices, ie the raid array and the
> internal disk. i know that i could at least put a control file on
> the internal disk but that won't save me from much. what i
> really need ( or want ) is the ability to recover as much as
> possible in case the raid array fails. am i asking too much?
> any suggestons/advice
> will be much apprieciated.
Although it is dependent on what kind of machine you are using there several things that you can try.
Offline Backups periodically.
Keep redo logs for a while.
Make sure that you have the archive redo log
turned on, I wouldn't imagine anyone running a
mission critical database without it.
When you have an instance or a media failure,
you can take the last offline backup and use
all of the redo to roll forward up to right before
the failure.
Make sure that you keep a couple of different tapes of the database file. If you get ready to restore the database and find that one of the tapes is bad, you can use the older tape.
On my SCO unix machine, I would keep the redo logs in a different filesystem from the database file.
Ocasionally you should do full database
exports to protect yourself from internal
corruption inside of the database.
signed a unemployed dba ..and looking for work. ========= ========= ========= ========= =========
Noah Monsey noah_at_indirect.com========= ========= ========= ========= ========= The only dumb question is the one that you don't ask. ========= ========= ========= ========= ========= Received on Fri May 19 1995 - 00:00:00 CEST