To open a database to read-only mode

Tag:database    database    opened   

Case 3: Opening a database to read-only mode

1. Open database directly to read-only mode

sql> startup open Read only;
ORACLE instance started.

Total System Global area 608174080 bytes
Fixed Size 1268920 bytes
Variable Size 230687560 bytes
Database buffers 373293056 bytes
Redo buffers 2924544 bytes
Database mounted.
Database opened.

Querying the read-write mode of the current database
Sql> select Open_mode from V$database;

Open_mode
----------
READ only

2. How to open the database to read-only mode in the Mount state

Sql> ALTER DATABASE open read only;

Database altered.

Sql> select Open_mode from V$database;

Open_mode
----------
READ only

3. In normal state, the database read/write mode is
Sql> select Open_mode from V$database;

Open_mode
----------
READ WRITE

To open a database to read-only mode