Chinaunix首页 | 论坛 | 博客
  • 博客访问: 153351
  • 博文数量: 56
  • 博客积分: 1435
  • 博客等级: 上尉
  • 技术积分: 640
  • 用 户 组: 普通用户
  • 注册时间: 2008-11-26 09:58
文章分类

全部博文(56)

文章存档

2009年(52)

2008年(4)

我的朋友

分类: LINUX

2008-11-28 16:57:55

quiesce状态即静默状态,可以用下面的SQL语句使得数据库处于quiesce状态:
alter system quiesce restricted;
quiesce状态下的数据库不能被non-dba用户连接,而dba用户仍然可以进行查询修改操作。
alter system unquiesce
可以将数据库设置成unquiesce状态。
quiesce and unquiesce are the new feature of 10g,they can alter db to restricted state without to shutdown and restart database,and eliminate the time exhaust.

in oracle which version prior to 10g,you can do this through the following command:
1,shutdown;
2,startup restricted;
which can made the db to restricted state,so the dba user can do some particular task.

compare to quiesce state,you can alter db to suspend state(停顿状态)for particular jobs;
the command as following:
alter system suspend.
in suspend state,all you can do is read data from db using dba user,you can't modify or insert data to db.
you can alter db to normal using :
alter system resume;
阅读(819) | 评论(0) | 转发(0) |
0

上一篇:oracle启动关闭

下一篇:linux下解决OEM乱码

给主人留下些什么吧!~~