Re: urgent recovery question

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Thu, 11 May 2006 07:40:15 +0200
Message-ID: <486b2b610605102240g6347d542me8b303b770fd247a@mail.gmail.com>

>Is the only way to circumvent this problem be to backup immediately after
loads?

Yes, is one reason why I don't like nologging operations in production.

>Question: Would flash recovery assist in recovery when datafiles are
deleted or corrupted?

Assuming you mean flashback database: No, as it relies on regular transactions, if the files no longer can be read or written, flashback database cannot use them either.

Stefan

On 5/11/06, Paula Stankus <paulastankus_at_yahoo.com> wrote:
>
> We had a database with some tablespaces marked as nologging
>
> Sys admin. copied files from backup on top of those files (hot backup)
>
> Tablespaces with "nologging" complianed about needing media recovery.
>
> Is the only way to circumvent this problem be to backup immediately after
> loads?
>
> Question: Would flash recovery assist in recovery when datafiles are
> deleted or corrupted?
>
> ------------------------------
> How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call
> rates.
> <http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>
>
>

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

Received on Thu May 11 2006 - 00:40:15 CDT