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.
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