Re: unrecoverable datafiles ?

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Wed, 26 Aug 2015 22:35:44 +0100
Message-ID: <9ABD5A8B-FB25-4BBC-B33C-AF216BE6E89A_at_dunbar-it.co.uk>

It sounds like you have had a NOLOGGING or UNRECOVERABLE or a direct load operation at some point. If you have had a full back since then, there's no need to worry. If not, I suggest a full backup ASAP.

You might want to ALTER DATABASE FORCE LOGGING to prevent this happening again. Up to 11.1 this needs the database in mount mode, from 11.2 it can be open.

You should always have force logging turned on on your primary and standby databases.

HTH Cheers.
Norm.

On 26 August 2015 20:00:33 BST, Chris King <ckaj111_at_yahoo.ca> wrote:
>Has anyone run into this before?
>
>I ran orachk on the Oracle RAC system and it reported the database has
>datafiles that are unrecoverable. As recommended, I then ran this
>command:
> rman > report unrecoverable database;
>
> There are no files listed.
>
> Then I ran this command:
>select file#, unrecoverable_time, unrecoverable_change# from v$datafile
>where unrecoverable_time is not null;
>
>on both the primary and standby, I get a list of five files, the same
>list on both primary and standby.
>However, the dates listed are all from January and February this year.
>
>Do I have unrecoverable datafiles? If so, how can I repair this? If
>not, how can I clean up so the sql query reports properly?
>

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

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

Received on Wed Aug 26 2015 - 23:35:44 CEST