Tuesday, August 1, 2023

Startup Modes In Oracle Database

 nomount mode

only parameter file is accessible.

this mode is only use to modify parameter file content/paramter.

mount mode

read control file but not validate its file content.

certain maintenance operation requires mount mode. ( RMAN backup restore recovery)

Note:- ******* its mandatory for "recover database"  that db should be in mount mode*******

parameter file, processes gets started and memory allocated for the instance.

open mode

start to read data files and redo logs 

No comments:

Post a Comment

Enable OpenSSH on Windows 11

Step 1: Install OpenSSH Server You can do this via PowerShell (run as Administrator ): Check if it's already available: Get-WindowsCapab...