Oracle database status and ARCHIVELOG MODE

Oracle Database STATUS and ARCHIVELOG MODE

Oracle database status and ARCHIVELOG MODE Running sqlplus / as sysdba is a command used to connect to an Oracle database with SYSDBA privileges.

Explain: –

sqlplus :- 

This means the Oracle connection Oracle database instance and executes SQL statements.

/ :-

This Means authentication doesn’t require a username and password 

as sysdba :-

This means that the connection should be made with SYSDBA privileges. SYSDBA is a special administrative privilege. 

This user performs high-level administrative tasks.

EX :-

starting up and shutting down the database.

Oracle database status Set Environment Variables (if necessary):-

Set the Oracle environment variables (ORACLE_HOME, PATH, etc.) are set correctly.

Once you are connected to Oracle database You can run the SQL query you provided below

SELECT
name,
open_mode,
log_mode,
status
FROM
v$database,
v$instance;

Explanation of the Query. :-

Name :-

It shows the name of the database from v$database.

Open Mode :-

It shows the open mode of the database from v$database.

Log Mode :-

It shows the log mode of the database from v$database.

Instance Status:-

It shows the status of the instance from v$instance.

Ex Output:-

This output gives you a quick overview of the database and instance status, 

it will be useful for DBAs for monitoring and management purposes.

Thank You