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;