Expanded controlfile section 11 from 448 to 896 records

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博客 ” ，链接：http://blog.itpub.net/35489/viewspace-659648/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-659648/