Startup nomount阶段:
- Find parameter file under $ORACLE_HOME/dbs
- Spfile<SID>.ora
- Spfile.ora
- Init<SID>.ora
- Init.ora
- Error
- Constructure memory(SGA)
- Start background processes
- Open alert<SID>.LOG
在nomount这个阶段可以做的事情
Re-create or controlfile
Startup mount(alter databasemount):
open all controlfiles according tocontrol_files parameter.
在mount这个阶段可以做的事情:
1.drop database
2.set archivelog mode
3.restore and recover
4.enable flashback
5.enable MRP
6.backup database under no-archivelog mode
startup(alter database open);
1.open all online datafiles
2.open all online log files