Saturday 8 June 2013

startup oracle database instance concepts

startup NOMOUNT: During startup nomount Instance started.It creates the SGA and starts up the background processes but does not provide access to the database.

startup MOUNT: During Startup mount Control file 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 opened as described by the control file for this instance.It enables users to access the database.

No comments:

Post a Comment