ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Expanded controlfile section 11 from 448 to 896 records

Expanded controlfile section 11 from 448 to 896 records

原创 Linux操作系统 作者:tolywang 时间:2010-03-18 06:22:46 0 删除 编辑

Oracle 10.2.0.4 .  Linux AS 5.3    64bit ,   在alert log 中发现了两次控制文件扩展的记录, 分别是扩展控制文件中的不同section ( section 9 及 section 11 ),    目前控制文件大小为 19M 。     

Sat Apr 10 20:58:27 2010
Thread 2 advanced to log sequence 247 (LGWR switch)
  Current log# 26 seq# 247 mem# 0: /b2bdata/oracle/oradata/wmb2bprd/redo26a.log
  Current log# 26 seq# 247 mem# 1: /b2bdata1/oracle/oradata/wmb2bprd/redo26b.log
Sat Apr 10 21:28:26 2010
Expanded controlfile section 9 from 292 to 584 records
Requested to grow by 292 records; added 1 blocks of records
Sat Apr 10 21:28:26 2010
Thread 2 advanced to log sequence 248 (LGWR switch)
  Current log# 19 seq# 248 mem# 0: /b2bdata/oracle/oradata/wmb2bprd/redo19a.log
  Current log# 19 seq# 248 mem# 1: /b2bdata1/oracle/oradata/wmb2bprd/redo19b.log  




Mon Apr 12 14:58:55 2010
Expanded controlfile section 11 from 448 to 896 records
Requested to grow by 448 records; added 16 blocks of records
Mon Apr 12 15:28:57 2010
Thread 2 advanced to log sequence 332 (LGWR switch)
  Current log# 23 seq# 332 mem# 0: /b2bdata/oracle/oradata/wmb2bprd/redo23a.log
  Current log# 23 seq# 332 mem# 1: /b2bdata1/oracle/oradata/wmb2bprd/redo23b.log

 

-------------------------------

我们可以查询  select * from v$controlfile_record_section ;  得出下面的一些控制文件中的section ,那么 Expanded controlfile section 9 from 292 to 584 records  这些信息中的  section 9 对应的应该是log history 这一个section ,  而 section 11 应该是 archived log 部分。 

 

0, 'DATABASE',

1, 'CKPT PROGRESS',

2, 'REDO THREAD',

3, 'REDO LOG',

4, 'DATAFILE',

5, 'FILENAME',

6, 'TABLESPACE',

7, 'TEMPORARY FILENAME',

8, 'RMAN CONFIGURATION',

9, 'LOG HISTORY',

10, 'OFFLINE RANGE',

11, 'ARCHIVED LOG',

12, 'BACKUP SET',

13, 'BACKUP PIECE',

14, 'BACKUP DATAFILE',

15, 'BACKUP REDOLOG',

16, 'DATAFILE COPY',

17, 'BACKUP CORRUPTION',

18, 'COPY CORRUPTION',

19, 'DELETED OBJECT',

20, 'PROXY COPY',

21, 'BACKUP SPFILE',

23, 'DATABASE INCARNATION',

24, 'FLASHBACK LOG',

25, 'RECOVERY DESTINATION',

26, 'INSTANCE SPACE RESERVATION',

27, 'REMOVABLE RECOVERY FILES',

28, 'RMAN STATUS',

29, 'THREAD INSTANCE NAME MAPPING',

30, 'MTTR',

31, 'DATAFILE HISTORY',

32, 'STANDBY DATABASE MATRIX',

33, 'GUARANTEED RESTORE POINT',

34, 'RESTORE POINT'



 

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

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    14695612