Database Reference
In-Depth Information
This command will erect the Instance with no database mounted
on it. No user would be able to connect or interact with the
instance except the logged in SYSDBA. This state is usually
used to create the new database.
STARTUP MOUNT
As a result of this command, the instance will mount the
database after being alive. No user would be able to interact or
access the information from the database. This state is usually
used to recover the database in case of failures.
STARTUP OPEN
OPEN is the default clause of STARTUP command i.e. if you
used execute STARTUP without any clause Oracle will take it as
STARTUP OPEN. In this, Oracle Instance will open the
database after making himself alive and then mounting the
database in this brain and finally opens it. In this state users
would be able to interact with the instance and access the data.
STARTUP RESTRICT
Starts the instance, mounts and opens the database but only users
with restricted session privileges would be able to access or
interact with the instance.
STARTUP RECOVER
Starts the instance but leaves the database closed and begins the
recovery for whatever failure happened.
STARTUP FORCE
Forces the instance to shutdown abort and immediately startup
open. This option is usually used with instance having problems
either starting or stopping. Its like OS reboot or restart command.
Like the STARTUP command, there is a command to shutdown
the instance or in other words oracle system (instance and
database) i.e. SHUTDOWN. Using this command we can
shutdown the database in four ways. Those four ways are
discussed below.
Search WWH ::
Custom Search