3.2 启动数据库到mount状态(控制文件打开,alter database mount)
从刚才的参数文件中获取控制文件位置,并打开。
Sat Sep 13 18:09:29 2008
alter database mount
Sat Sep 13 18:09:33 2008
Successful mount of redo thread 1, with mount id 467611545. ——记录mount id
Sat Sep 13 18:09:33 2008
Database mounted in Exclusive Mode.
Completed: alter database mount ——mount成功
3.3 启动数据库到open状态(实例中控制文件描述的所有文件打开,alter database open)
打开控制文件中记录的数据文件、日志文件等,并进行检查点和完整性检查。如一切OK,即对外提供数据库服务。
Sat Sep 13 18:09:40 2008
alter database open
Sat Sep 13 18:09:40 2008
Thread 1 opened at log sequence 61
Current log# 1 seq# 61 mem# 0: D:\ORACLE\ORADATA\ORATEST\REDO01.LOG
Successful open of redo thread 1.
Sat Sep 13 18:09:40 2008
SMON: enabling cache recovery
Sat Sep 13 18:09:40 2008
Undo Segment 1 Onlined
Undo Segment 2 Onlined
……(此处省略部分参数)
Successfully onlined Undo Tablespace 1. ——在线undo表空间
Sat Sep 13 18:09:40 2008
SMON: enabling tx recovery
Sat Sep 13 18:09:41 2008
Database Characterset is ZHS16GBK ——打印出此数据库字符集
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open ——打开数据库成功
责任编辑:小草