PROMPTING;
CONNECT TO DB2688 user sdcgd using 1qaz2WSX;
UNQUIESCE DATABASE;
CONNECT RESET;
QUIESCE、UNQUIESCE 的含义:
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;
2、增量备份
必须设定:
数据库参数
trackmod
设置为
on,在配置参数后,必须进行
一次数据库完全备份
(相应错误处理:
DB2 增量备份:
1.
通过将
TRACKMOD 数据库配置参数设置为打开来激活数据库的修
改跟踪,然后执行完全数据库备份。(若仍不成功,试
2)