archive_lag_target参数说明

Thu Apr 10 12:53:37 2008
ALTER SYSTEM SET archive_lag_target=600 SCOPE=BOTH;
Thu Apr 10 12:53:38 2008
Thread 1 advanced to log sequence 20
  Current log# 1 seq# 20 mem# 0: /dev/md/haset/rdsk/d10
  Current log# 1 seq# 20 mem# 1: /dev/md/haset/rdsk/d11
Thu Apr 10 13:03:40 2008
Thread 1 cannot allocate new log, sequence 21
Private strand flush not complete
  Current log# 1 seq# 20 mem# 0: /dev/md/haset/rdsk/d10
  Current log# 1 seq# 20 mem# 1: /dev/md/haset/rdsk/d11
Thread 1 advanced to log sequence 21
  Current log# 2 seq# 21 mem# 0: /dev/md/haset/rdsk/d12
  Current log# 2 seq# 21 mem# 1: /dev/md/haset/rdsk/d13

从ＡＬＥＲＴ中可以看出该参数的作用，我设置的６００秒归档一次．这对于那些由于业务高峰ＲＥＤＯ切换比较频繁，但是平时切换比较慢的用户，为防止意外减少数据丢失有很大的帮助．

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

转载于:http://blog.itpub.net/7882490/viewspace-232355/