Database Administration (MOSC)

MOSC Banner

12.2.0.1 : dgmrl validate database / Insufficient SRLs

edited Apr 9, 2022 1:34AM in Database Administration (MOSC) 9 commentsAnswered

Hi ,

DGMGRL> show configuration

Configuration - dg_proddb

 Protection Mode: MaxPerformance

 Members:

 proddbp - Primary database

  proddbs - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS  (status updated 57 seconds ago)

But , SRL error has been encountered when trying to execute the following command :

DGMGRL> validate database proddbs

 Database Role:   Physical standby database

 Primary Database: proddbp

 Ready for Switchover: Yes

 Ready for Failover:  Yes (Primary Running)

 Flashback Database Status:

  proddbp: Off

  proddbs: Off

 Managed by Clusterware:

  proddbp: YES

  proddbs: YES

 Current Log File Groups Configuration:

  Thread # Online Redo Log Groups Standby Redo Log Groups Status

       (proddbp)        (proddbs)

  1     4            4            Insufficient SRLs


 Future Log File Groups Configuration:

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