Database Administration (MOSC)

MOSC Banner

Updating DB_FILES parameter for Primary and Standyby Databases

"Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0"

We are hitting ORA-00059 - maximum number of DB_FILES. I am trying to find out if we can do this work without bringing both the primary and standby servers down. All the documentation I find is about how RAC DB has to be completely stopped. But what about primary/standby? Can standby be brought down, then up with new DB_FILES parameter, switched to Primary and then the original Primary restarted to pick up the change. This way we don't have any/minimal down time.

Thanks in advance.

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