Database Administration (MOSC)

MOSC Banner

REDO LOG ONLINE only in the FRA?!!

edited Feb 20, 2025 3:56PM in Database Administration (MOSC) 7 commentsAnswered

Hello,

I'm checking the oracle database in our compagny, i discover that Redo log online are only exist in the FRA (6 Groupes composed only by the 1 member )

+FRA/CG/ONLINELOG/group_5.1732.1163601613
+FRA/CG/ONLINELOG/group_6.1956.1163601941
+FRA/CG/ONLINELOG/group_1.388.1163602021
+FRA/CG/ONLINELOG/group_4.910.1163601539
+FRA/CG/ONLINELOG/group_2.909.1163602073
+FRA/CG/ONLINELOG/group_3.904.1163602125

And for controle file, this configuration :

Name IS_RECOVERY_DEST_FILE
+DATA/CG/CONTROLFILE/current.1058.1163603381 NO
+FRA/CGL/CONTROLFILE/current.2089.1163427765 YES

I'm very confused by this configuration, I think that there is some thing wrong her ?!!

Normally, the REDO LOG Online should be in the +DATA ?!!

Please advice

Thank you

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