Pages

Tuesday, March 29, 2016

Startup Oracle Database Instance

Startup Oracle Database Instance

Startup NOMOUNT:
During startup nomount Instance is started. It creates the SGA and starts up the background processes, and we need pfile/spfile for nomount the database and it doesn't provide access to the database.

Startup MOUNT:
During Startup mount Control file is created and opened for this instance.It mounts the database for certain DBA activities but does not provide user access to the database.

Alter database OPEN:
During startup database all the files get's opened as described by the control file for this instance. And it enables users to access the database.

No comments:

Post a Comment