Startup shutdown modes oracle database – Activity
In this post, we will perform an activity on startup and shutdown modes of Oracle database.The startup modes include startup open, startup mount, startup nomount and
shutdown modes include shutdown abort, shutdown transactional, shutdown normal, shutdown immediate.
Also read the startup and shutdown modes of Oracle database concept.
Database shutdown modes
They are of four types
- Shutdown normal or shutdown
- Shutdown transactional
- Shutdown immediate
- Shutdown abort
Database Startup modes
They are
- startup nomount
- startup mount
- startup open
STARTUP NOMOUNT
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SQL> startup nomount; ORACLE instance started. Total System Global Area 3340451840 bytes Fixed Size 2217952 bytes Variable Size 1862273056 bytes Database Buffers 1459617792 bytes Redo Buffers 16343040 bytes SQL> |
A database in nomount state can be mounted using the following command
|
1 2 3 |
SQL> alter database mount; Database altered. |
A database in mount state can be opened using the following command
|
1 2 3 |
SQL> alter database open; Database altered. |
A database which is in opened state cannot be mounted back.
|
1 2 3 4 5 6 7 8 9 10 11 |
SQL> SQL> alter database mount; alter database mount ERROR at line 1: ORA-01100: database already mounted |
Database shutdown modes
Shutting down the database with immediate option
|
1 2 3 4 5 6 7 8 9 10 11 |
SQL> SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> |
an excerpt from alert log file for shut immediate
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
Sat Mar 31 16:46:48 2018 Shutting down instance (immediate) Stopping background process FBDA Shutting down instance: further logons disabled Stopping background process QMNC Sat Mar 31 16:46:49 2018 Stopping background process CJQ0 Stopping background process MMNL Stopping background process MMON License high water mark = 4 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL ... ... Sat Mar 31 16:46:58 2018 Instance shutdown complete |
Shutting down the database with abort option
|
1 2 3 4 5 |
SQL> shut abort; ORACLE instance shut down. SQL> |
an excerpt from alert log file for shut abort
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
Shutting down instance (abort) License high water mark = 1 USER (ospid: 4341): terminating the instance Instance terminated by USER, pid = 4341 Sat Mar 31 16:48:39 2018 Instance shutdown complete |
If the database is terminated by shut abort, the instance recovery is performed on next startup.
An excerpt from alert log file during startup after shut abort
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 |
Sat Mar 31 16:49:11 2018 ALTER DATABASE OPEN Beginning crash recovery of 1 threads parallel recovery started with 3 processes Started redo scan Completed redo scan read 51 KB redo, 41 data blocks need recovery Started redo application at Thread 1: logseq 7, block 501 Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0 Mem# 0: /u01/TEST/redo01.log Completed redo application of 0.03MB Completed crash recovery at Thread 1: logseq 7, block 604, scn 1501421 41 data blocks read, 41 data blocks written, 51 redo k-bytes read LGWR: STARTING ARCH PROCESSES Sat Mar 31 16:49:11 2018 ARC0 started with pid=24, OS id=4692 ARC0: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC0: STARTING ARCH PROCESSES Thread 1 advanced to log sequence 8 (thread open) Sat Mar 31 16:49:12 2018 ARC1 started with pid=25, OS id=4694 Sat Mar 31 16:49:12 2018 ARC2 started with pid=26, OS id=4696 Thread 1 opened at log sequence 8 Current log# 2 seq# 8 mem# 0: /u01/TEST/redo02.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set SMON: enabling cache recovery ARC1: Archival started ARC2: Archival started ARC2: Becoming the 'no FAL' ARCH ARC2: Becoming the 'no SRL' ARCH ARC1: Becoming the heartbeat ARCH Sat Mar 31 16:49:12 2018 ARC3 started with pid=27, OS id=4698 Archived Log entry 20 added for thread 1 sequence 7 ID 0x8750d057 dest 1: Successfully onlined Undo Tablespace 2. Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed SMON: enabling tx recovery Database Characterset is WE8MSWIN1252 No Resource Manager plan active Starting background process FBDA Sat Mar 31 16:49:12 2018 FBDA started with pid=28, OS id=4700 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC Sat Mar 31 16:49:12 2018 QMNC started with pid=29, OS id=4704 Completed: ALTER DATABASE OPEN Sat Mar 31 16:49:13 2018 db_recovery_file_dest_size of 3072 MB is 5.44% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. |