Re: re NOLOGGING/LOGGING

"Hemant K Chitale" <hkchital_nospam_at_singnet_nospam.com.sg> wrote in message news:adik4n$7vl$1_at_clematis.singnet.com.sg...
>
> The "until 9iR2 of course when you can set the database to FORCE logging
> even if
> someone tries NOLOGGING"
> is good.
>
> A DBA might want everything in the RedoLogs but some
> smart developer writes a job NoLogging and the DBA is not
> aware of it. What happens when the data doesn't go to the
> standby or the DBA has to recover from a backup ?
> Who's neck is on the block when the data is "gone, disappeared, missing" ?

The DBA's. You knew there was a good reason to build working relationships with your developers and not just give them a hard time right?

Of course when the developer is a third party this option may not be open to you. Its still your fault though!

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************