Re: I need one opinion and one answer

"Van Messner" <vmessner_at_netaxis.com> wrote:

]Opinions Please

<snip>
]files (and even mirrored), but I don't know enough about raid5 to tell
]whether we're protected against disk failure. The company takes a complete
]cold backup of each database every night. But they say they can't afford to
]lose part of a day's data if we crash after some of the redo logs have been
]archived. Is this a danger or does raid5 protect us?

Raid 5 CAN be set up so you are protected. You will have to check out your Raid 5 configuration. I'd feel comfortable if the config had a hot spare.

]Question

<snip>
]do a backup controlfile to trace I see that nine of the databases have
]archivemode set to yes and one has it set to no. The one that has it set to
]no is not producing any archived redo logs
<snip>
]logs? Where is the setting being overridden?

It's a control file thing. Shutdown the database, then startup mount (I think) and alter database archivelogmode Then open the database.

--
 ,-,_|\ George Dau - Unix (Solaris, DEC Unix, Linux), Oracle, Internet. __

/    * \ Home: gedau_at_pobox.com         !  Any views or opinions expressed (OO)
\_,--\_/ Work: gedau_at_isa.mim.com.au    !  above may be mine, but are NOT ( \/ )
      v   WWW: http://pobox.com/~gedau !  necessarily those of M.I.M.     W--W