|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
startup startup nomount startup mount startup restrict startup open recover startup pfile = /path/to/init.ora
In order to startup an instance, one needs to be connected as sysdba or as sysoper.
An instance is terminated with shutdown.
Only the instance is started. That is the SGA is allocated and the background processes are started.
Neither controlfiles are mounted nor database opened.
Instance is started and controlfiles mounted, but database not opened.
Instance is started and controlfiles mounted and database opened.
Oracle records startups of the instance in the alert.log file.
See also startup.
ORA-01031 when starting an instance.