[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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 8.13 標頭檔案剖析：標頭檔案路徑（下）
- locate標頭檔案和庫檔案
- №20191009◆手遊1~8◆
- 標頭檔案講解
- 祖傳標頭檔案
- 標頭檔案的作用分析
- 使用 header 頭下載檔案Header
- 什麼是 標頭檔案
- VSCode 配置檔案頭的snippetVSCode
- 02@在類的標頭檔案中儘量少引入其他標頭檔案
- C/C++標頭檔案太難記？一個萬能標頭檔案全搞定！C++
- linux下使用windows標頭檔案LinuxWindows
- C語言 - 標頭檔案包含C語言
- idea檔案頭資訊設定Idea
- c++筆記_標頭檔案C++筆記
- 關於C++的標頭檔案C++
- 檢視BAM檔案頭部資訊
- 8.10 標頭檔案剖析：變數宣告變數
- 8.11 標頭檔案剖析：前向引用
- 8.14 Linux核心中的標頭檔案Linux
- 8.8 標頭檔案剖析：基本概念
- C/C++標頭檔案一覽C++
- 看標頭檔案猜演算法演算法
- pycharm設定python標頭檔案模版PyCharmPython
- openGauss libpq使用依賴的標頭檔案
- system資料檔案頭損壞修復
- macos新增c++萬能標頭檔案MacC++
- C++ include標頭檔案引入規則C++
- algorithm標頭檔案下的常用函式Go函式
- string.h標頭檔案（字串函式）字串函式
- python3檔案開頭怎麼寫Python
- [20210429]檔案頭塊不會快取.txt快取
- gcc g++ 新增標頭檔案路徑和庫檔案路徑的方法GC
- 巨集_變數_函式_指標_標頭檔案變數函式指標
- gcc 標頭檔案依賴關係 分析工具GC
- 雖然包含string標頭檔案但未用std::
- C語言關於標頭檔案的使用C語言
- 使用 Visual Studio 2019 批量新增程式碼檔案頭