ORACLE databse start-up scenarios

 

 

Restart after crash

SQL> startup restrict;

 

SQL> shutdown immediate;

 

SQL> startup;

 

Don’t forget to check the alert.log to assure the final start-up was clean!

 

Restart hanged database

 

SQL> select name from v$database;

 

SQL> shutdown abort;

 

SQL> startup restrict;

 

SQL> shutdown immediate;

 

SQL> startup;

 

Don’t forget to check the alert.log to assure the final start-up was clean!

 

Start up with specific init.ora

Use when you lost spfile or want to start up with non standard config:

 

SQL> startup pfile=<PATHNAME>/<INITORA>;

 

Example:

 

SQL> startup pfile=/u01/app/oracle/db_home/dbs/initproddb01.ora;

 

Rounded Rectangle: Home Page