轉載 控制檔案(controlfile)中的各個section 代表什麼 ?
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',
[@more@]-------------------------------------------------
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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12180666/viewspace-1018939/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 控制檔案(controlfile)中的各個section 代表什麼 ?
- 關於控制檔案的擴充套件問題 (全面) - Expanded controlfile section套件
- 10g R2 中控制檔案自動擴充套件 - Expanded controlfile section套件
- Oracle 控制檔案(CONTROLFILE)Oracle
- Oracle 控制檔案(CONTROLFILE) -- <2>Oracle
- Oracle 控制檔案(CONTROLFILE)- <1>Oracle
- oracle之 利用 controlfile trace檔案重建控制檔案Oracle
- Oracle基礎 06 控制檔案 controlfileOracle
- python中的class代表什麼Python
- ELF檔案中的各個節區
- 【實驗】從RMAN備份中恢復controlfile控制檔案
- 重建控制檔案--alter database backup controlfile to traceDatabase
- 冷備控制檔案 & Using Backup Controlfile
- 【轉載】控制檔案中的 MAXDATAFILES 和 DB_FILES 關係
- 查詢檔案中的控制字元(轉)字元
- Android中VSYNC代表什麼Android
- Controlfile 重建控制檔案 noresetlogs, resetlogs..
- 檔案許可權中 chmod、u+x、u、r、w、x分別代表什麼
- [轉載] 瞭解raw trace檔案的各項內容
- Python中\t代表什麼?如何使用?Python
- 關於using backup controlfile(丟失控制檔案和資料檔案)
- CONFIGURE CONTROLFILE AUTOBACKUP OFF下恢復控制檔案
- Linux中檔案顏色代表型別Linux型別
- JavaScript 中的 SOLID 原則(四):“I”代表什麼JavaScriptSolid
- 【知識分享】伺服器中的u代表什麼伺服器
- JavaScript 中的 SOLID 原則(一):“S”代表什麼JavaScriptSolid
- 關於正則的 符號,獲取控制 都代表什麼意思?符號
- ORACLE控制檔案的重建 (轉)Oracle
- 轉儲 控制檔案
- 小黑需知 各種系統中密碼檔案的位置(轉)密碼
- 多個控制檔案的建立
- 各檔案系統對單個檔案大小的限制
- redhat as,ws,es代表什麼?Redhat
- oracle controlfile檔案之三Oracle
- 控制檔案詳解(轉)
- 分析什麼是專案管理中的質量控制(QC)?專案管理
- postgresql中pg_class relkind有幾個值,分別代表什麼含義SQL
- linux下的各項配置檔案(轉)Linux