轉載 控制檔案(controlfile)中的各個section 代表什麼 ?

lhyvsxman發表於2009-03-18
Thu Mar 5 08:19:59 2009
ARC0: Evaluating archive log 8 thread 1 sequence 3274
ARC0: Unable to archive log 8 thread 1 sequence 3274
Log actively being archived by another process
Thu Mar 5 08:19:59 2009
ARCH: Completed archiving log 8 thread 1 sequence 3274
Thu Mar 5 08:32:09 2009
Thread 1 advanced to log sequence 3276
Thu Mar 5 08:32:09 2009
ARC1: Evaluating archive log 2 thread 1 sequence 3275
Thu Mar 5 08:32:09 2009
Current log# 3 seq# 3276 mem# 0: /u01/product/oradata/ultimus/redo03a.log
Current log# 3 seq# 3276 mem# 1: /data/ultimus/redo03b.log
Thu Mar 5 08:32:09 2009
ARC1: Beginning to archive log 2 thread 1 sequence 3275
Creating archive destination LOG_ARCHIVE_DEST_1: '/data/ultimus/arch/1_3275.arc'
ARC1: Completed archiving log 2 thread 1 sequence 3275
Thu Mar 5 08:43:06 2009
kccrsz: expanded controlfile section 15 from 107 to 214 records
requested to grow by 107 record(s); added 1 block(s) of records
Clearing standby activation ID 4229415552 (0xfc17c280)
The primary database controlfile was created using the
'MAXLOGFILES 20' clause.
There is space for up to 12 standby redo logfiles
Use the following commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl6.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl7.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl8.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl9.f' SIZE 52428800;
Thu Mar 5 08:51:35 2009
Thread 1 advanced to log sequence 3277
Thu Mar 5 08:51:35 2009
Current log# 4 seq# 3277 mem# 0: /u01/product/oradata/ultimus/redo04a.log
Current log# 4 seq# 3277 mem# 1: /data/ultimus/redo04b.log
Thu Mar 5 08:51:35 2009
ARC1: Evaluating archive log 3 thread 1 sequence 3276

控制檔案中的section 代表什麼 ?

kccrsz: expanded controlfile section 15 from 107 to 214 records

從 v$controlfile_record_section , section 代表 BACKUP REDOLOG .


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',

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

SQL> select * from v$controlfile_record_section;

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID
-------------------- ----------- ------------- ------------ ----------- ---------- ----------
DATABASE 316 1 1 0 0 0
CKPT PROGRESS 4084 4 0 0 0 0
REDO THREAD 228 1 1 0 0 0
REDO LOG 72 5 4 0 0 10
DATAFILE 428 200 126 0 0 274
FILENAME 268 216 138 0 0 0
TABLESPACE 68 200 18 0 0 67
TEMPORARY FILENAME 56 200 4 0 0 14
RMAN CONFIGURATION 1108 50 13 0 0 53
LOG HISTORY 36 65535 65535 64300 64299 178639
OFFLINE RANGE 180 226 0 0 0 0
ARCHIVED LOG 328 65535 65535 65535 65534 123694
BACKUP SET 40 204 204 41 40 3304
BACKUP PIECE 480 408 408 151 150 10350
BACKUP DATAFILE 116 492 492 412 411 11871
BACKUP REDOLOG 76 3761 3761 2111 2110 122462
DATAFILE COPY 404 404 404 94 93 901
BACKUP CORRUPTION 44 371 0 0 0 0
COPY CORRUPTION 40 204 0 0 0 0
DELETED OBJECT 20 4084 4084 2259 2258 134988
PROXY COPY 596 411 0 0 0 0
BACKUP SPFILE 36 226 226 31 30 934
DATABASE INCARNATION 56 145 1 1 1 1

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12180666/viewspace-1018939/,如需轉載,請註明出處,否則將追究法律責任。

相關文章