启动和停止数据库——启动例程并打开数据库
1.启动例程
conn sys/sys as sysdba startup nomount
2.nomount 状态转为mount状态
alter database mount; alter database open;
3.启动例程并装载数据库
startup mount
4.启动例程装载并打开数据库
startup open
5.以受限模式打开数据库
startup restrict
6.以只读模式打开数据库
conn sys/sys as sysdba shutdown immediate startup mount alter database open read only; update scott.emp set sal=1000 where empno=70;
posted on 2013-05-13 22:11 LinuxPanda 阅读(281) 评论(0) 编辑 收藏 举报