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
No comments:
Post a Comment