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@xxxxxxxx> 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?
