Re: Pls Help Interview Question

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 24 May 2006 12:46:32 GMT
Message-Id: <pan.2006.05.24.12.46.32.807262@sbcglobal.net>

On Tue, 23 May 2006 23:14:28 -0700, peter wrote:

>
> hi Respected DBAs,
>
> database in noarchivelog mode, I don't have backup and my one data file
> got corrupted.
> How to recover database with minmum lost.

You can't. No archive logs means no recovery. Period. You can only restore the whole database from a cold backup.

>
> and
>
> how to check which datafile is corrupt before any error shown by
> database while working.
> means any package or through any oracle utility.

V$RECOVER_FILE will show you that.

>
> Pls help
>
> Thank You

So, what are you interviewing for?

-- 
http://www.mgogala.com

Received on Wed May 24 2006 - 07:46:32 CDT