Check Oracle Database in Read/Write Mode

Share this article :

You can use below query to check is your Oracle database in read/write mode or not.

SQL> select open_mode from v$database;


Related posts

Oracle Database Architecture
V$ARCHIVE_DEST: Archived Redo Log Instance Destinations State
V$BACKUP_CORRUPTION: Datafile Backup Corrupt Block Ranges
RMAN: ORA-12154: TNS:could not resolve the connect identifier specified
© 2018 ITsiti. All Rights Reserved
Powered by KEEM