Maintaining Online Redo Log Files-1

一：Forcing Log Switches and Checkpoints

? Forcing a log switch:

ALTER SYSTEM SWITCH LOGFILE;

? Checkpoints can be forced by:

– Setting FAST_START_MTTR_TARGET parameter

FAST_START_MTTR_TARGET = 600

注意点一：设置FAST_START_MTTR_TARGET主要为了增加dbwn的次数，避免有时lgwr完毕之后，dbwn未发生而导致

db的等待。

注意点二：FAST_START_MTTR_TARGET parameter replaces the deprecated parameters:

?FAST_START_IO_TARGET

?LOG_CHECKPOINT_TIMEOUT

These deprecated parameters must not be used if the parameter

FAST_START_MTTR_TARGET is used.也就是说设置FAST_START_MTTR_TARGET之后，FAST_START_IO_TARGET，

LOG_CHECKPOINT_TIMEOUT，这两个参数是NOT BE USED的。

 

二：Adding Online Redo Log File Groups

例：

ALTER DATABASE ADD LOGFILE GROUP 3

('$HOME/ORADATA/u01/log3a.rdo',

'$HOME/ORADATA/u02/log3b.rdo')

SIZE 1M;

 

语法：

ALTER DATABASE [database]

ADD LOGFILE [GROUP integer] filespec

[, [GROUP integer] filespec]...]

三：Adding Online Redo Log File Members

例：

ALTER DATABASE ADD LOGFILE MEMBERS

'$HOME/ORADATA/u04/log1c.rdo' TO GROUP 1,

'$HOME/ORADATA/u04/log2c.rdo' TO GROUP 2,

'$HOME/ORADATA/u04/log3c.rdo' TO GROUP 3;

语法：

ALTER DATABASE [database]

ADD LOGFILE MEMBER

[ 'filename' [REUSE]

[, 'filename' [REUSE]]...

TO {GROUP integer

|('filename'[, 'filename']...)

}

]...

If the file already exists, it must havethe same size, and you must specify the

REUSE option.

Member的几种种状态：

Valid，正常

Invalid，不可访问

Stale，可访问，db怀疑该文件不正确或已经损坏。

Deleted：指明这个文件不存在

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29840459/viewspace-1479643/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29840459/viewspace-1479643/