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.