오라클 19c controlfile 에 저장하고 있는 정보 확인

OS환경 : Oracle Linux 7.6 (64bit)

 

DB 환경 : Oracle Database 19.3.0.0

 

방법 : 오라클 19c controlfile 에 저장하고 있는 정보 확인

v$controlfile_record_section 뷰 확인

SQL> select rownum,t.* from v$controlfile_record_section t;
 
    ROWNUM TYPE             RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID     CON_ID
---------- ---------------------------- ----------- ------------- ------------ ----------- ---------- ---------- ----------
     1 DATABASE                316        1         1         0        0           0      0
     2 CKPT PROGRESS               8180           11         0         0        0           0      0
     3 REDO THREAD                256        8         1         0        0           0      0
     4 REDO LOG                 72           16         3         0        0           0      0
     5 DATAFILE                520          100         4         0        0           0      0
     6 FILENAME                524         2298         7         0        0           0      0
     7 TABLESPACE                180          100         5         0        0           1      0
     8 TEMPORARY FILENAME             56          100         0         0        0           0      0
     9 RMAN CONFIGURATION               1108           50         2         0        0           5      0
    10 LOG HISTORY                 56          292         1         1        1           1      0
    11 OFFLINE RANGE            200          163         0         0        0           0      0
    12 ARCHIVED LOG             584          308         3         1        3           3      0
    13 BACKUP SET                 96          170         0         0        0           0      0
    14 BACKUP PIECE             780          209         0         0        0           0      0
    15 BACKUP DATAFILE            200          245         0         0        0           0      0
    16 BACKUP REDOLOG             76          215         0         0        0           0      0
    17 DATAFILE COPY            736          200         0         0        0           0      0
    18 BACKUP CORRUPTION             44          371         0         0        0           0      0
    19 COPY CORRUPTION             40          409         0         0        0           0      0
    20 DELETED OBJECT             20          818         0         0        0           0      0
    21 PROXY COPY                928          246         0         0        0           0      0
    22 BACKUP SPFILE            124          131         0         0        0           0      0
    23 DATABASE INCARNATION          56          292         1         1        1           1      0
    24 FLASHBACK LOG             84         2048         0         0        0           0      0
    25 RECOVERY DESTINATION         180        1         0         0        0           0      0
    26 INSTANCE SPACE RESERVATION         28         1055         0         0        0           0      0
    27 REMOVABLE RECOVERY FILES         32         1000         0         0        0           0      0
    28 RMAN STATUS                116          141         4         1        4           4      0
    29 THREAD INSTANCE NAME MAPPING      80        8         8         0        0           0      0
    30 MTTR                 100        8         1         0        0           0      0
    31 DATAFILE HISTORY            568           57         0         0        0           0      0
    32 STANDBY DATABASE MATRIX        400          128       128         0        0           0      0
    33 GUARANTEED RESTORE POINT        256         2048         0         0        0           0      0
    34 RESTORE POINT            256         2108         0         0        0           0      0
    35 DATABASE BLOCK CORRUPTION         80         8384         0         0        0           0      0
    36 ACM OPERATION            104           64        11         0        0           0      0
    37 FOREIGN ARCHIVED LOG         604         1002         0         0        0           0      0
    38 PDB RECORD                780           10         0         0        0           0      0
    39 AUXILIARY DATAFILE COPY        584          128         0         0        0           0      0
    40 MULTI INSTANCE REDO APPLY        556        1         0         0        0           0      0
    41 PDBINC RECORD            144          113         0         0        0           0      0
    42 TABLESPACE KEY HISTORY        108          151         0         0        0           0      0
 
42 rows selected.

 

참조 :