Oracle 12c 12.1.0.1.0管理控制文件官方文档翻译说明
时间:2022-03-13 22:36
View Description
V$DATABASE
Displays database information from the control file
从控制文件中显示数据库的信息
V$CONTROLFILE
Lists the names of control files
控制文件名清单
V$CONTROLFILE_RECORD_SECTION
Displays information about control file record sections
控制文件记录信息
V$PARAMETER
Displays the names of control files as specified in the CONTROL_FILES
initialization parameter
显示在CONTROL_FILES初始化参数里指定的控制文件名
This example lists the names of the control files.
查看控制文件的名称及位置(两种方法):
SYS@db12c>descv$controlfile;
Name Null? Type
--------------------------------------------------------------------------------------------------------------------- --------------------------------------------------
STATUS VARCHAR2(7)
NAME VARCHAR2(513)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
BLOCK_SIZE NUMBER
FILE_SIZE_BLKS NUMBER
CON_ID NUMBER
SYS@db12c>colname for a80
SYS@db12c>select * from v$controlfile;
STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS CON_ID
--------------------------------------------------------------------------------------- --- ---------- ------------- ----------
/u01/app/oracle/oradata/DB12C/controlfile/o1_mf_9xcyo7gc_.ctl NO 16384 1096 0
/u01/app/oracle/fast_recovery_area/DB12C/controlfile/o1_mf_9xcyo80x_.ctl YES 16384 1096 0
/u01/app/oracle/oradata/DB12C/controlfile/control02.ctl NO 16384 1096 0
SYS@db12c>show parameter control_files
NAME TYPE VALUE
------------------------------------ -----------------------------------------
control_files string /u01/app/oracle/oradata/DB12C/controlfile/o1_mf_9xcyo7gc_.ctl,
/u01/app/oracle/fast_recovery_area/DB12C/controlfile/o1_mf_9xcyo80x_.ctl,/u01/app/oracle/oradata/DB12C/controlfile/control02.ctl
SYS@db12c>
---
查询控制文件中可记载的最大数据文件个数
SYS@db12c>desc V$CONTROLFILE_RECORD_SECTION
Name Null? Type
------------------------------------------------------------- ------------------------------------
TYPE VARCHAR2(28)
RECORD_SIZE NUMBER
RECORDS_TOTAL NUMBER
RECORDS_USED NUMBER
FIRST_INDEX NUMBER
LAST_INDEX NUMBER
LAST_RECID NUMBER
CON_ID NUMBER
SYS@db12c>select * from V$CONTROLFILE_RECORD_SECTION;
TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEXLAST_RECID CON_ID
---------------------------- ----------- ------------- ----------------------- ---------- ---------- ----------
DATABASE 316 1 1 0 0 0 0
CKPT PROGRESS 8180 11 0 0 0 0 0
REDO THREAD 256 8 1 0 0 0 0
REDO LOG 72 16 3 0 0 15 0
DATAFILE 520 1024 11 0 0 123 0
FILENAME 524 4146 20 0 0 0 0
TABLESPACE 68 1024 13 0 0 9 0
TEMPORARY FILENAME 56 1024 3 0 0 165 0
RMAN CONFIGURATION 1108 50 0 0 0 0 0
LOG HISTORY 56 292 25 1 25 25 0
OFFLINE RANGE 200 1063 8 1 8 8 0
TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEXLAST_RECID CON_ID
---------------------------- ----------- ------------- ----------------------- ---------- ---------- ----------
ARCHIVED LOG 584 28 14 1 14 14 0
BACKUP SET 96 1022 1 1 1 1 0
BACKUP PIECE 780 1006 1 1 1 1 0
BACKUP DATAFILE 200 1063 1 1 1 1 0
BACKUP REDOLOG 76 215 0 0 0 0 0
DATAFILE COPY 736 1000 6 1 6 6 0
BACKUP CORRUPTION 44 1115 0 0 0 0 0
COPY CORRUPTION 40 1227 0 0 0 0 0
DELETED OBJECT 20 818 8 1 8 8 0
PROXY COPY 928 1004 0 0 0 0 0
BACKUP SPFILE 124 131 1 1 1 1 0
TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEXLAST_RECID CON_ID
---------------------------- ----------- ------------- ----------------------- ---------- ---------- ----------
DATABASE INCARNATION 56 292 2 1 2 2 0
FLASHBACK LOG 84 2048 0 0 0 0 0
RECOVERY DESTINATION 180 1 1 0 0 0 0
INSTANCE SPACE RESERVATION 28 1055 1 0 0 0 0
REMOVABLE RECOVERY FILES 32 1000 0 0 0 0 0
RMAN STATUS 116 141 6 1 6 6 0
THREAD INSTANCE NAME MAPPING 80 8 8 0 0 0 0
MTTR 100 8 1 0 0 0 0
DATAFILE HISTORY 568 57 0 0 0 0 0
STANDBY DATABASE MATRIX 400 31 31 0 0 0 0
GUARANTEED RESTORE POINT 212 2048 0 0 0 0 0
TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEXLAST_RECID CON_ID
---------------------------- ----------- ------------- ----------------------- ---------- ---------- ----------
RESTORE POINT 212 2083 0 0 0 0 0
DATABASE BLOCK CORRUPTION 80 8384 0 0 0 0 0
ACM OPERATION 104 64 9 0 0 0 0
FOREIGN ARCHIVED LOG 604 1002 0 0 0 0 0
PDB RECORD 684 10 3 0 0 9 0
AUXILIARY DATAFILE COPY 584 128 0 0 0 0 0
MULTI INSTANCE REDO APPLY 556 1 0 0 0 0 0
PDBINC RECORD 144 113 0 0 0 0 0
41 rows selected.
SYS@db12c>
Oracle 12c 12.1.0.1.0管理控制文件官方文档翻译说明,布布扣,bubuko.com