I'm trying to understand the different ways to achieve read-only status in Oracle:
- Setting the instance parameter INSTANCE_MODE to READ_ONLY
- Using ALTER DATABASE OPEN READ ONLY
I'd like to understand:
- What's the fundamental difference between these two approaches?
- When should I use one over the other?
I've searched the documentation but would appreciate some real-world insights and explanations from experienced DBAs.
Thanks in advance!