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

opatchauto

# Log in as root su - root # Execute opatchauto against the unzipped patch directory /u01/app/19.0.0/ grid /OPatch/opatchauto apply /tmp/pat...