Database Startup and Shutdown Sequence - Database Administration

Database_Startup_Mode:

======================

Shutdown 

startup nomount;

alter database mount;

alter database open;

Shutdown 

startup mount; 

alter database open;

Shutdown 

startup;  

startup open;

v$instance_Vs_v$database:

=========================

DEVDB v$instance    Vs v$database 

Shutdown N/A         N/A

Nomount STARTED         N/A 

Mount MOUNTED MOUNTED

Open OPEN READ WRITE   

select instance_name, status from v$instance;

select name, open_mode from v$database;

Database_Shutdown_Options:

===========================

shutdown abort; - NA

shutdown immediate; best option 

shutdown transactional; 

shutdown normal;

Logs:

[oracle@oraclelab1 ~]$ ps -ef|grep smon

oracle   17221     1  0 00:32 ?        00:00:00 ora_smon_DEVDB

oracle   18249 14921  0 00:39 pts/0    00:00:00 grep --color=auto smon

[oracle@oraclelab1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Feb 1 00:39:52 2024

Version 19.17.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.17.0.0.0

SQL> shutdown abort;

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 3690985856 bytes

Fixed Size                  8903040 bytes

Variable Size             889192448 bytes

Database Buffers         2785017856 bytes

Redo Buffers                7872512 bytes

Database mounted.

Database opened.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 3690985856 bytes

Fixed Size                  8903040 bytes

Variable Size             889192448 bytes

Database Buffers         2785017856 bytes

Redo Buffers                7872512 bytes

Database mounted.

Database opened.

SQL> shutdown transactional;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 3690985856 bytes

Fixed Size                  8903040 bytes

Variable Size             889192448 bytes

Database Buffers         2785017856 bytes

Redo Buffers                7872512 bytes

Database mounted.

Database opened.

SQL> shutdown normal;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 3690985856 bytes

Fixed Size                  8903040 bytes

Variable Size             889192448 bytes

Database Buffers         2785017856 bytes

Redo Buffers                7872512 bytes

Database mounted.

Database opened.

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.17.0.0.0

[oracle@oraclelab1 ~]$

Regards,

Mallik