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

MOSC Banner

Datafile is infinitely media recovery fuzzy Standby database will not open with this datafile onlin

File system (FS) backup has been taken on standby oracle database while SRL (Standby Log recovery) is going through ODG.

Then, after stopping the database the backup has been resotred. After restoration, when tried to open the database in read write mode, getting the following error - "Datafile  is infinitely media recovery fuzzy Standby database will not open with this datafile online!"

Tried to apply the archive logs using MRP process but still getting the same error.

Run following queries on database -

SQL> select db_unique_name,current_scn,database_role from v$database;

DB_UNIQUE_NAME                 CURRENT_SCN DATABASE_ROLE

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