[20191009]檔案頭fuzzy.txt
[20191009]檔案頭fuzzy.txt
--//查詢檢視v$datafile_header,僅僅能看到fuzzy兩種狀態YES.NO.
--//我在連結:http://blog.itpub.net/267265/viewspace-2134630/=>[20170302]fuzzy儲存在那裡.txt
--//提到儲存fuzzy在檔案頭偏移138處.bbed 使用kcvfh.kcvfhsta表示.
--//是否在情況下具體數值不是很清楚，做一些測試驗證看看。
1.環境:
SCOTT@test01p> @ ver1
PORT_STRING VERSION BANNER CON_ID
-------------------- ---------- ---------------------------------------------------------------------------- ------
IBMPC/WIN_NT64-9.1.0 12.2.0.1.0 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0
SYS@test> column VIEW_DEFINITION format a100
SYS@test> select * from V$FIXED_VIEW_DEFINITION where view_name ='GV$DATAFILE_HEADER';
VIEW_NAME VIEW_DEFINITION CON_ID
-------------------- ---------------------------------------------------------------------------------------------------- ----------
GV$DATAFILE_HEADER select inst_id,hxfil,decode(hxons, 0, 'OFFLINE', 'ONLINE'),decode(hxerr, 0, NULL, 1,'FILE MISSING',2 0
,'OFFLINE NORMAL', 3,'NOT VERIFIED', 4,'FILE NOT FOUND',5,'CANNOT OPEN FILE', 6,'CANNOT READ HEADER'
, 7,'CORRUPT HEADER',8,'WRONG FILE TYPE', 9,'WRONG DATABASE', 10,'WRONG FILE NUMBER',11,'WRONG FILE
CREATE', 12,'WRONG FILE CREATE', 16,'DELAYED OPEN',14, 'WRONG RESETLOGS', 15,'OLD CONTROLFILE', 'UNK
NOWN ERROR'),hxver,decode(hxnrcv, 0,'NO', 1,'YES', NULL),decode(hxifz, 0,'NO', 1,'YES', NULL),to_num
ber(fhcrs),to_date(fhcrt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),fhtnm,fhtsn,fhrfn,to_number
(fhrls),to_date(fhrlc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),to_number(fhscn),to_date(fhtim
,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),fhcpc,fhfsz*fhbsz,fhfsz,hxfnm, decode(hxlmdba, 0, N
ULL, hxlmdba), decode(hxlmld_scn, to_number('0'), NULL, hxlmld_scn), decode(hxuopc_scn, 0, NULL, hxu
opc_scn), con_id, decode(bitand(fhsparse, 1), 0, 'NO', 'YES'), decode(bitand(fhkeyflg, 1), 0, 'NO',
'YES') from x$kcvfh
--//格式化語句如下:
/* Formatted on 2019/10/9 19:45:33 (QP5 v5.227.12220.39754) */
SELECT inst_id
,hxfil
,DECODE (hxons, 0, 'OFFLINE', 'ONLINE')
,DECODE
(
hxerr
,0, NULL
,1, 'FILE MISSING'
,2, 'OFFLINE NORMAL'
,3, 'NOT VERIFIED'
,4, 'FILE NOT FOUND'
,5, 'CANNOT OPEN FILE'
,6, 'CANNOT READ HEADER'
,7, 'CORRUPT HEADER'
,8, 'WRONG FILE TYPE'
,9, 'WRONG DATABASE'
,10, 'WRONG FILE NUMBER'
,11, 'WRONG FILE CREATE'
,12, 'WRONG FILE CREATE'
,16, 'DELAYED OPEN'
,14, 'WRONG RESETLOGS'
,15, 'OLD CONTROLFILE'
,'UNKNOWN ERROR'
)
,hxver
,DECODE (hxnrcv, 0, 'NO', 1, 'YES', NULL)
,DECODE (hxifz, 0, 'NO', 1, 'YES', NULL)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
,TO_NUMBER (fhcrs)
,TO_DATE (fhcrt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')
,fhtnm
,fhtsn
,fhrfn
,TO_NUMBER (fhrls)
,TO_DATE (fhrlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')
,TO_NUMBER (fhscn)
,TO_DATE (fhtim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')
,fhcpc
,fhfsz * fhbsz
,fhfsz
,hxfnm
,DECODE (hxlmdba, 0, NULL, hxlmdba)
,DECODE (hxlmld_scn, TO_NUMBER ('0'), NULL, hxlmld_scn)
,DECODE (hxuopc_scn, 0, NULL, hxuopc_scn)
,con_id
,DECODE (BITAND (fhsparse, 1), 0, 'NO', 'YES')
,DECODE (BITAND (fhkeyflg, 1), 0, 'NO', 'YES')
FROM x$kcvfh;
--//下劃線顯示的就是fuzzy.而x$kcvfh.hxifz僅僅2個值0,1對應NO,YES.很明顯與實際檔案頭記錄的fuzzy不一樣.看看各種情況下該值的情況.
2.測試:
RMAN> report schema ;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name TEST
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 900 SYSTEM YES D:\APP\ORACLE\ORADATA\TEST\SYSTEM01.DBF
2 210 PDB$SEED:SYSTEM NO D:\APP\ORACLE\ORADATA\TEST\PDBSEED\SYSTEM01.DBF
3 1040 SYSAUX NO D:\APP\ORACLE\ORADATA\TEST\SYSAUX01.DBF
4 165 PDB$SEED:SYSAUX NO D:\APP\ORACLE\ORADATA\TEST\PDBSEED\SYSAUX01.DBF
5 655 UNDOTBS1 YES D:\APP\ORACLE\ORADATA\TEST\UNDOTBS01.DBF
6 205 PDB$SEED:UNDOTBS1 NO D:\APP\ORACLE\ORADATA\TEST\PDBSEED\UNDOTBS01.DBF
7 5 USERS NO D:\APP\ORACLE\ORADATA\TEST\USERS01.DBF
8 260 TEST01P:SYSTEM YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF
9 215 TEST01P:SYSAUX NO D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSAUX01.DBF
10 280 TEST01P:UNDOTBS1 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\UNDOTBS01.DBF
11 528 TEST01P:USERS NO D:\APP\ORACLE\ORADATA\TEST\TEST01P\USERS01.DBF
36 100 TEST01P:LFREE NO D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 62 TEMP 32767 D:\APP\ORACLE\ORADATA\TEST\TEMP01.DBF
2 20 PDB$SEED:TEMP 32767 D:\APP\ORACLE\ORADATA\TEST\PDBSEED\TEMP01.DBF
3 200 TEST01P:TEMP 32767 D:\APP\ORACLE\ORADATA\TEST\TEST01P\TEMP01.DBF
SYS@test> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- ---------------
1 11107573 2019-10-09 19:26:19 9 1 ONLINE 3066 YES D:\APP\ORACLE\ORADATA\TEST\SYSTEM01.DBF SYSTEM
2 1102125 2018-10-06 23:24:44 227 1 ONLINE 37 NO D:\APP\ORACLE\ORADATA\TEST\PDBSEED\SYSTEM01.DBF SYSTEM
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11111214 2019-10-09 19:39:54 3718607 1 ONLINE 2986 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
--//透過bbed觀察,說明windows bbed存在+1偏移.一般在linux下訪問塊頭,執行dba N,1.
BBED> p dba 1,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x2004 (KCVFHOFZ)
BBED> p dba 2,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x2000 (NONE)
BBED> p dba 8,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x2004 (KCVFHOFZ)
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0004 (KCVFHOFZ)
--//可以看出在system資料檔案在open 讀寫的情況下,kcvfh.kcvfhsta=0x2004.而read onlt的情況下0x2000,
--//而其它資料檔案在open 讀寫的情況下,kcvfh.kcvfhsta=0x0004.
--//system資料檔案與普通資料檔案kcvfh.kcvfhsta(16進位制)前者前面2,後者是0.
3.測試在熱備份的情況下:
SCOTT@test01p> alter tablespace lfree begin backup ;
Tablespace altered.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------ ---------------- --- -------------------------------------------------- --------------------
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11113518 2019-10-09 20:02:41 3718607 1 ONLINE 2987 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0001 (KCVFHHBP)
--//可以發現在熱備份模式下kcvfh.kcvfhsta= 0x0001.對應的v$datafile_header.fuzzy="YES".
SCOTT@test01p> alter tablespace lfree end backup ;
Tablespace altered.
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0004 (KCVFHOFZ)
4.測試表空間offline的情況下:
SCOTT@test01p> alter tablespace lfree offline ;
Tablespace altered.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 0 0 0 OFFLINE 0
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0000 (NONE)
SCOTT@test01p> alter tablespace lfree online ;
Tablespace altered.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11113676 2019-10-09 20:07:47 3718607 1 ONLINE 2990 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0004 (KCVFHOFZ)
--//測試表空間offline immediate看看:
SCOTT@test01p> alter tablespace lfree offline immediate;
Tablespace altered.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11113676 2019-10-09 20:07:47 3718607 1 OFFLINE 2990 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0004 (KCVFHOFZ)
SCOTT@test01p> recover tablespace lfree;
Media recovery complete.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11113717 2019-10-09 20:08:45 3718607 1 OFFLINE 2991 NO D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0000 (NONE)
SCOTT@test01p> alter tablespace lfree online;
Tablespace altered.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11113866 2019-10-09 20:12:06 3718607 1 ONLINE 2992 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0004 (KCVFHOFZ)
5.測試表空間read only的情況:
SCOTT@test01p> alter tablespace lfree read only ;
Tablespace altered.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11113904 2019-10-09 20:13:02 3718607 1 ONLINE 2993 NO D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0000 (NONE)
SCOTT@test01p> alter tablespace lfree read write ;
Tablespace altered.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11113934 2019-10-09 20:13:46 3718607 1 ONLINE 2995 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0004 (KCVFHOFZ)
6.測試資料檔案offline的情況:
SCOTT@test01p> alter database datafile 36 offline ;
Database altered.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11113934 2019-10-09 20:13:46 3718607 1 OFFLINE 2995 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0004 (KCVFHOFZ)
SCOTT@test01p> recover datafile 36;
Media recovery complete.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11114396 2019-10-09 20:14:45 3718607 1 OFFLINE 2996 NO D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0000 (NONE)
SCOTT@test01p> alter database datafile 36 online ;
Database altered.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11111214 2019-10-09 19:39:54 1103550 1 ONLINE 3136 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11114455 2019-10-09 20:16:12 3718607 1 ONLINE 2997 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 36,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x0004 (KCVFHOFZ)
7.總結:
--//可以大致總結如下:
--//對於普通資料檔案:
fuzzy=Yes .kcvfh.kcvfhsta = 0x0004 ,0x0001(熱備份模式)
fuzzy=NO kcvfh.kcvfhsta = 0x0000
--//對於system資料檔案,僅僅前面有0x2:
fuzzy=Yes .kcvfh.kcvfhsta = 0x2004 ,0x2001(熱備份模式)
fuzzy=NO kcvfh.kcvfhsta = 0x2000
--//補充測試system表空間熱備份的情況:
SCOTT@test01p> alter tablespace system begin backup ;
Tablespace altered.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11114579 2019-10-09 20:20:43 1103550 1 ONLINE 3137 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11114455 2019-10-09 20:16:12 3718607 1 ONLINE 2997 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 8,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x2001 (KCVFHHBP)
SCOTT@test01p> alter tablespace system end backup ;
Tablespace altered.
SCOTT@test01p> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE# , RESETLOGS_CHANGE#,status,CHECKPOINT_COUNT,fuzzy,name,tablespace_name FROM v$datafile_header where file# in (1,2,8,36);
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ NAME TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- --------------------
8 11114579 2019-10-09 20:20:43 1103550 1 ONLINE 3138 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF SYSTEM
36 11114455 2019-10-09 20:16:12 3718607 1 ONLINE 2997 YES D:\APP\ORACLE\ORADATA\TEST\TEST01P\LFREE05X.DBF LFREE
BBED> p dba 8,2 kcvfh.kcvfhsta
ub2 kcvfhsta @138 0x2004 (KCVFHOFZ)
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-2659273/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- wav檔案的檔案頭
- 8.13 標頭檔案剖析：標頭檔案路徑（下）
- locate標頭檔案和庫檔案
- PHP檔案頭BOM頭問題PHP
- C 標頭檔案
- PE檔案檢測DOS頭\NT頭
- #include sys/xxx.h標頭檔案 UNIX標頭檔案
- C 標頭檔案 作用
- Oracle檔案頭資訊(zt)Oracle
- 祖傳標頭檔案
- 標頭檔案講解
- Java解析ELF檔案：使用Java讀取檔案頭部、節區頭部表、程式頭部表Java
- 標頭檔案與庫檔案與菜鳥 (轉)
- 標頭檔案的作用分析
- fcntl.h標頭檔案
- 各種型別檔案頭型別
- linux 標頭檔案 作用Linux
- 轉儲日誌檔案頭
- bbed 與檔案頭恢復
- 什麼是 標頭檔案
- 02@在類的標頭檔案中儘量少引入其他標頭檔案
- 資料檔案拷貝檔案頭驗證錯誤
- C/C++標頭檔案太難記？一個萬能標頭檔案全搞定！C++
- 使用 header 頭下載檔案Header
- c++筆記_標頭檔案C++筆記
- idea檔案頭資訊設定Idea
- JS檔案放在頭還是尾JS
- Nt函式原型標頭檔案函式原型
- 檢視BAM檔案頭部資訊
- C語言 - 標頭檔案包含C語言
- java通過檔案頭內容判斷檔案型別Java型別
- 大型專案開發: 標頭檔案順序
- C/C++標頭檔案一覽C++
- linux下使用windows標頭檔案LinuxWindows
- 關於C++的標頭檔案C++
- 8.8 標頭檔案剖析：基本概念
- VSCode 配置檔案頭的snippetVSCode
- C++ 預編譯標頭檔案C++編譯