High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

System and Sysaux files show up in v$recover_file in dataguard environment

In my 12.1.0.2 database,  SYSTEM and SYSAUX datafiles belonging to my PDB$SEED is listed in v$recover_file view. I have Dataguard setup in this testbox and it's in sync with primary database.

Can someone please tell me why these files show up in this view?

I ran this command on both Primary and Standby DB and got the same output

SQL> select * from v$recover_file;

     FILE# ONLINE  ONLINE_

---------- ------- -------

ERROR                                                                CHANGE#

----------------------------------------------------------------- ----------

TIME          CON_ID

--------- ----------

         2 ONLINE  ONLINE

                                                                     2243160

09-AUG-16          2

         4 ONLINE  ONLINE

                                                                     2243160

09-AUG-16          2

     FILE# ONLINE  ONLINE_

---------- ------- -------

ERROR                                                                CHANGE#

----------------------------------------------------------------- ----------

TIME          CON_ID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center