{"id":4397,"date":"2019-01-15T15:19:30","date_gmt":"2019-01-15T06:19:30","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4397"},"modified":"2019-01-15T15:19:30","modified_gmt":"2019-01-15T06:19:30","slug":"dbv-utility%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-file-check","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4397","title":{"rendered":"DBV Utility\ub97c \uc774\uc6a9\ud55c File Check"},"content":{"rendered":"

<\/a>1<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\ud14c\uc2a4\ud2b8\u00a0<\/span><\/span>\ud658\uacbd<\/span><\/span><\/span><\/h1>\n

n<\/span>\u00a0 <\/span><\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>\uc11c\ubc84<\/span><\/span> : Sun Enterprise E3500 (2048M)<\/span><\/span><\/p>\n

n<\/span>\u00a0 <\/span><\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>\uc6b4\uc601\uccb4\uc81c<\/span><\/span> : Solaris 9<\/span><\/span><\/p>\n

n<\/span>\u00a0 <\/span><\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>\uc624\ub77c\ud074<\/span><\/span> : Oracle 10.2.0.4 Enterprise 64bit<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

<\/a>2<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>DBV Utility<\/span><\/span><\/h1>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Database verify <\/span><\/span>\uc758\u00a0<\/span>\uc57d\uc790\ub85c<\/span>, 7.3.2 <\/span>\ubd80\ud130\u00a0<\/span>\uc9c0\uc6d0\ub418\ub294\u00a0<\/span>\uc720\ud2f8\ub9ac\ud2f0<\/span><\/span>.<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Data <\/span><\/span>\ub098\u00a0<\/span>Index block <\/span>\uc774\u00a0<\/span>\uc5b4\ub290\u00a0<\/span>\uc815\ub3c4\u00a0<\/span>\uc2e0\ub8b0\uc131\uc774\u00a0<\/span>\uc788\ub294\uc9c0<\/span>, <\/span>\uc190\uc0c1<\/span>(corruption)<\/span>\uc758\u00a0<\/span>\uc720\ubb34\uc5d0\u00a0<\/span>\ub300\ud55c\u00a0<\/span>\uc815\ub3c4\ub97c\u00a0<\/span>\uc810\uac80<\/span><\/span>. <\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>dbv <\/span><\/span>\ub294\u00a0<\/span>Block level <\/span>\uae4c\uc9c0\ub9cc\u00a0<\/span>\uc810\uac80\ud558\uae30\u00a0<\/span>\ub54c\ubb38\uc5d0<\/span>, ‘ANALYZE TABLE … VALIDATE STRUCTURE CASCADE’ <\/span>\uc640\ub294\u00a0<\/span>\ub2ec\ub9ac\u00a0<\/span>Index <\/span>\uc640\u00a0<\/span>Data block <\/span>\uac04\uc758\u00a0<\/span>\uc77c\uce58\uc131\u00a0<\/span>\uc810\uac80\uc740\u00a0<\/span>\uc218\ud589\ud558\uc9c0\ub294\u00a0<\/span>\uc54a\ub294\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>dbv <\/span><\/span>\ub294\u00a0<\/span>Analyze <\/span>\uc2dc\u00a0<\/span>Table lock(TM) <\/span>\uc774\u00a0<\/span>\uac78\ub9ac\ub294\u00a0<\/span>\ubb38\uc81c\u00a0<\/span>\ub54c\ubb38\uc5d0<\/span>, Analyze <\/span>\ud560\u00a0<\/span>\uc218\u00a0<\/span>\uc5c6\ub294\u00a0<\/span>\uc0c1\ud669\uc5d0\uc11c\u00a0<\/span>\uc720\uc6a9\ud558\uac8c\u00a0<\/span>\uc0ac\uc6a9\ub420\u00a0<\/span>\uc218\u00a0<\/span>\uc788\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Keyword<\/span><\/span><\/b><\/p>\n<\/td>\n

\n

Description<\/span><\/span><\/b><\/p>\n<\/td>\n

\n

(Default)<\/span><\/span><\/b><\/p>\n<\/td>\n<\/tr>\n

\n

FILE<\/span><\/span><\/p>\n<\/td>\n

\n

File to Verify<\/span><\/span><\/p>\n<\/td>\n

\n

(NONE)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

START<\/span><\/span><\/p>\n<\/td>\n

\n

Start Block<\/span><\/span><\/p>\n<\/td>\n

\n

(First Block of File)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

END<\/span><\/span><\/p>\n<\/td>\n

\n

End Block<\/span><\/span><\/p>\n<\/td>\n

\n

(Last Block of File)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

BLOCKSIZE<\/span><\/span><\/p>\n<\/td>\n

\n

Logical Block Size<\/span><\/span><\/p>\n<\/td>\n

\n

(8192)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

LOGFILE<\/span><\/span><\/p>\n<\/td>\n

\n

Output Log<\/span><\/span><\/p>\n<\/td>\n

\n

(NONE)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

FEEDBACK<\/span><\/span><\/p>\n<\/td>\n

\n

Display Progress<\/span><\/span><\/p>\n<\/td>\n

\n

(0)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

PARFILE<\/span><\/span><\/p>\n<\/td>\n

\n

Parameter File<\/span><\/span><\/p>\n<\/td>\n

\n

(NONE)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

USERID<\/span><\/span><\/p>\n<\/td>\n

\n

Username\/Password<\/span><\/span><\/p>\n<\/td>\n

\n

(NONE)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

SEGMENT_ID<\/span><\/span><\/p>\n<\/td>\n

\n

Segment ID (tsn.relfile.block)<\/span><\/span><\/p>\n<\/td>\n

\n

(NONE)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

HIGH_SCN<\/span><\/span><\/p>\n<\/td>\n

\n

Highest Block SCN To Verify (scn_wrap.scn_base OR scn)<\/span><\/span><\/p>\n<\/td>\n

\n

(NONE)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

<\/a>3<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>DBV Utility <\/span><\/span>\uc0ac\uc6a9\ubc95<\/span><\/span><\/span><\/h1>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>dbv <\/span><\/span>\uc720\ud2f8\ub9ac\ud2f0\ub294<\/span> data file<\/span>\uc5d0\u00a0<\/span>\ub300\ud574\uc11c\ub9cc\u00a0<\/span>\uc0ac\uc6a9\ub420\u00a0<\/span>\uc218\u00a0<\/span>\uc788\uace0<\/span> Redo log <\/span>\ub098<\/span> control file <\/span>\uc5d0\u00a0<\/span>\ub300\ud574\uc11c\ub294\u00a0<\/span>\uc0ac\uc6a9\ud560\u00a0<\/span>\uc218\u00a0<\/span>\uc5c6\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>raw device <\/span><\/span>\uc5d0\u00a0<\/span>\ub300\ud574\uc11c\ub294\u00a0<\/span>\uc9c1\uc811<\/span> dbv <\/span>\ub97c\u00a0<\/span>\uc218\ud589\ud560\u00a0<\/span>\uc218\u00a0<\/span>\uc5c6\uace0<\/span> symbolic link <\/span>\ub97c\u00a0<\/span>\uc0ac\uc6a9\ud574\uc57c\u00a0<\/span>\ud55c\ub2e4<\/span>. <\/span>\uadf8\ub9ac\uace0<\/span> link name<\/span>\uc740\u00a0<\/span>\ubc18\ub4dc\uc2dc\u00a0<\/span>\ud655\uc7a5\uc790<\/span>(extension)<\/span>\ub97c\u00a0<\/span>\uc918\uc57c\ud55c\ub2e4<\/span><\/span>. <\/span><\/span><\/p>\n

(ln -s \/dev\/rvol\/users \/oracle\/users01.dbf)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

n<\/span>\u00a0 <\/span><\/span><\/span><\/span>\uc77c\ubc18\uc801\uc778<\/span><\/span> File<\/span>\uc758\u00a0<\/span><\/span>\uc0ac\uc6a9\ubc95<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\ub9cc\uc57d<\/span><\/span> ASM<\/span>\ub97c\u00a0<\/span>\uc0ac\uc6a9\ud558\ub294\u00a0<\/span>\uacbd\uc6b0\uc5d0\ub294\u00a0<\/span>\ubc18\ub4dc\uc2dc<\/span> userid<\/span>\ub97c\u00a0<\/span>\ub123\uc5b4\uc918\uc57c\ub9cc\u00a0<\/span>\ud55c\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n

(Ex : dbv file=+DG1\/ORCL\/datafile\/system01.dbf userid=system\/sys)<\/span><\/span><\/p>\n\n\n\n
\n

$ dbv file=<\/span><\/span>\ud30c\uc77c\uba85<\/span><\/span> blocksize=8192<\/span><\/span><\/p>\n

\"clip_image003[4]\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\ub9cc\uc57d<\/span><\/span> dbv<\/span>\ub97c\u00a0<\/span>\uc2e4\ud589\ud55c\u00a0<\/span>\uacb0\uacfc\uc5d0\uc11c\u00a0<\/span>Marked Corrupt <\/span>\ub098<\/span> Failing <\/span>\uc774\u00a0<\/span>\uc788\ub2e4\uba74<\/span>, <\/span>\ub2e4\uc2dc<\/span> dbv <\/span>\ub97c\u00a0<\/span>\uc218\ud589\ud558\uc5ec\u00a0<\/span>\uc77c\uc2dc\uc801\uc778\u00a0<\/span>\ud604\uc0c1\uc778\uc9c0\u00a0<\/span>\ud655\uc778\ud55c\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

n<\/span>\u00a0 <\/span><\/span><\/span><\/span>Raw Device<\/span><\/span>\uc758\u00a0<\/span><\/span>\uc0ac\uc6a9\ubc95<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\ud30c\uc77c\uba85\uc740<\/span><\/span> ln -s \/dev\/rvol\/users \/oracle\/users01.dbf <\/span>\uc640\u00a0<\/span>\uac19\uc774<\/span> symbolic link<\/span>\ub97c\u00a0<\/span>\uac78\uc5b4\uc11c\u00a0<\/span>\ub123\uc5b4\uc900\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Start=1<\/span><\/span>\ub85c\u00a0<\/span>\uc124\uc815\uc744\u00a0<\/span>\ud558\uace0\u00a0<\/span>End<\/span>\ub294\u00a0<\/span>datafile<\/span>\uc758<\/span> bytes<\/span>\ub97c<\/span> db_block_size<\/span>\ub85c\u00a0<\/span>\ub098\ub208\u00a0<\/span>\uac12\uc744\u00a0<\/span>\ub123\ub294\ub2e4<\/span><\/span>. <\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n
\n

End <\/span><\/span>\uac12\u00a0<\/span>\uad6c\ud558\ub294\u00a0<\/span><\/span>\ubc29\ubc95<\/span><\/span><\/p>\n

SQL> show parameter
\ndb_block_size<\/span><\/span><\/p>\n

\"clip_image006[4]\"<\/a><\/span><\/p>\n

\u25cf<\/span> \uc704\uc5d0\uc11c\u00a0<\/span>\uad6c\ud55c<\/span> db_block_size<\/span>\ub97c\u00a0<\/span>\uad6c\ud558\ub824\ub294<\/span> datafile<\/span>\uc758<\/span> bytes <\/span>\uac12\uc73c\ub85c\u00a0<\/span>\ub098\ub204\uba74\u00a0<\/span>\uc5bb\uc744\u00a0<\/span>\uc218\u00a0<\/span>\uc788\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SQL> select bytes\/8192 from
\nv$datafile where file#=2;<\/span><\/span><\/p>\n

\"clip_image009[4]\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\uc704\uc5d0\uc11c<\/span><\/span> \uad6c\ud55c\u00a0<\/span>\uac12\uc744<\/span> end <\/span>\uac12\uc73c\ub85c\u00a0<\/span>\ub123\uc5b4\uc11c\u00a0<\/span>\uc2e4\ud589\uc744\u00a0<\/span>\ud558\uba74\u00a0<\/span>\ub41c\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n\n\n\n
\n

$ dbv file=<\/span><\/span>\ud30c\uc77c\uba85<\/span> blocksize=8192 start=1 end= (bytes\/db<\/span><\/span>_block_size)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\"clip_image012[4]\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>SEGMENT_ID<\/span><\/span>\ub97c\u00a0<\/span>\uc774\uc6a9\ud574\uc11c\u00a0<\/span>\ud2b9\uc815<\/span> Segment<\/span>\ub9cc\u00a0<\/span>\uc9c0\uc815\ud558\uc5ec\u00a0<\/span>\uc0ac\uc6a9\ud560\u00a0<\/span>\uc218\ub3c4\u00a0<\/span>\uc788\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n\n\n\n
\n

SQL> select t.ts#, s.header_file, s.header_block from v$tablespace t, dba_segments s<\/span><\/span><\/p>\n

where s.segment_name=’EMP_TEST’ and t.name = s.tablespace_name<\/span><\/span><\/p>\n

\"clip_image015[4]\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\uc704<\/span><\/span> \uc608\uc81c\ucc98\ub7fc\u00a0<\/span>\uc6d0\ud558\ub294<\/span> Segment<\/span>\uc758<\/span> TS#, HEADER_FILE, HEADER_BLOCK<\/span>\ub97c\u00a0<\/span>\uad6c\ud558\uc5ec\uc11c<\/span> dbv<\/span>\ub97c\u00a0<\/span>\uc774\uc6a9\ud558\uc5ec<\/span> Check<\/span>\ub97c\u00a0<\/span>\ud560\u00a0<\/span>\uc218\u00a0<\/span>\uc788\ub2e4<\/span>. Segment<\/span>\ub9cc\u00a0<\/span>\uc0ac\uc6a9\ud560\u00a0<\/span>\uacbd\uc6b0\uc5d0\ub294<\/span> userid<\/span>\ub97c\u00a0<\/span>\ub123\uc5b4\uc918\uc57c\u00a0<\/span>\ud55c\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n\n\n\n
\n

$ dbv userid=system\/oracle segment_id=4.10.851<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\"clip_image018[4]\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span>\u00a0<\/span><\/span><\/p>\n

n<\/span>\u00a0 <\/span><\/span><\/span><\/span>Corrupt <\/span><\/span>\ub41c<\/span> Object <\/span>\ud655\uc778\u00a0<\/span><\/span>\ubc29\ubc95<\/span><\/span><\/p>\n\n\n\n
\n

\u25cf<\/span>\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><\/strong>Corrupt<\/span><\/span><\/strong>\uac00\u00a0<\/span><\/strong>\ubc1c\uc0dd\ub41c\u00a0<\/span><\/strong>\ucd9c\ub825\u00a0<\/span><\/strong><\/span>\uc608\uc81c<\/span><\/span><\/strong><\/p>\n

\n\n\n\n
\n

DBVERIFY: Release 10.2.0.4.0 – Production on Wed Apr 28 00:35:15 2010<\/span><\/span><\/p>\n

Copyright (c) 1982, 2007, Oracle.\u00a0 <\/span>All rights reserved.<\/span><\/span><\/p>\n

DBVERIFY – Verification starting : FILE = users01.dbf<\/span><\/span><\/p>\n

Page 48740 is marked corrupt<\/span><\/span><\/strong><\/b>\u00a0\u00a0\u00a0 ***
\nCorrupt block relative dba: 0x01c0be64 (file 4, block 48740)
\nBad check value found during dbv:
\nData in bad block –
\ntype:
\n0 format: 2 rdba: 0x0000be64
\nlast change scn:
\n0x0000.00000000 seq: 0x1 flg: 0x05
\nconsistency value in tail: 0x00000001
\ncheck
\nvalue in block header: 0xb964, computed block checksum: 0x2a5a
\nspare1: 0x0, spare2: 0x0, spare3: 0x0
\n***
\nDBVERIFY – Verification
\ncomplete
\nTotal Pages
\nExamined\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 64000
\nTotal Pages Processed (Data) : 0
\nTotal Pages Failing\u00a0\u00a0 (Data) : 0
\nTotal Pages
\nProcessed (Index): 1751
\nTotal Pages
\nFailing\u00a0\u00a0 (Index): 0
\nTotal Pages Processed
\n(Other): 45
\nTotal Pages Processed (Seg)\u00a0 : 0
\nTotal Pages Failing\u00a0\u00a0 (Seg)\u00a0 : 0
\nTotal Pages
\nEmpty\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :
\n62203
\nTotal Pages Marked Corrupt\u00a0\u00a0 :
\n1<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/strong><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span>\u00a0<\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\uc704\uc640<\/span><\/span> \uac19\uc774<\/span> Corrupt<\/span>\ub41c\u00a0<\/span>\uc608\uc81c\ub97c\u00a0<\/span>\uc0b4\ud3b4\ubcf4\uba74\u00a0<\/span>\uad00\ub828<\/span> file<\/span>\uacfc<\/span> block<\/span>\uc744\u00a0<\/span>\ud655\uc778\u00a0<\/span>\ud560\u00a0<\/span>\uc218\u00a0<\/span>\uc788\ub2e4<\/span>. File<\/span>\uacfc<\/span> block<\/span>\ub97c\u00a0<\/span>\uc774\uc6a9\ud558\uc5ec<\/span> corrupt<\/span>\ub41c<\/span> Object<\/span>\ub97c\u00a0<\/span>\ud655\uc778\u00a0<\/span>\ud560\u00a0<\/span>\uc218\u00a0<\/span>\uc788\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n\n\n\n
\n

SQL > select segment_name, segment_type, owner\u00a0 from dba_extents<\/span><\/span>\u00a0<\/span>\u00a0<\/span>where file_id = (Absolute file number) and (corrupted block number) between block_id<\/span><\/span>\u00a0and block_id + blocks -1;<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\"clip_image022[5]\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

1\u00a0\u00a0\u00a0\u00a0\u00a0 \ud14c\uc2a4\ud2b8\u00a0\ud658\uacbd n\u00a0 \u00a0\uc11c\ubc84 : Sun Enterprise E3500 (2048M) n\u00a0 \u00a0\uc6b4\uc601\uccb4\uc81c : Solaris 9 n\u00a0 \u00a0\uc624\ub77c\ud074 : Oracle 10.2.0.4 Enterprise 64bit \u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0 DBV Utility –\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Database verify \uc758\u00a0\uc57d\uc790\ub85c, 7.3.2 \ubd80\ud130\u00a0\uc9c0\uc6d0\ub418\ub294\u00a0\uc720\ud2f8\ub9ac\ud2f0. –\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Data \ub098\u00a0Index block \uc774\u00a0\uc5b4\ub290\u00a0\uc815\ub3c4\u00a0\uc2e0\ub8b0\uc131\uc774\u00a0\uc788\ub294\uc9c0, \uc190\uc0c1(corruption)\uc758\u00a0\uc720\ubb34\uc5d0\u00a0\ub300\ud55c\u00a0\uc815\ub3c4\ub97c\u00a0\uc810\uac80. –\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dbv \ub294\u00a0Block level \uae4c\uc9c0\ub9cc\u00a0\uc810\uac80\ud558\uae30\u00a0\ub54c\ubb38\uc5d0, ‘ANALYZE TABLE … VALIDATE STRUCTURE CASCADE’ \uc640\ub294\u00a0\ub2ec\ub9ac\u00a0Index \uc640\u00a0Data block \uac04\uc758\u00a0\uc77c\uce58\uc131\u00a0\uc810\uac80\uc740\u00a0\uc218\ud589\ud558\uc9c0\ub294\u00a0\uc54a\ub294\ub2e4. –\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dbv \ub294\u00a0Analyze […]<\/p>\n","protected":false},"author":1,"featured_media":4141,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[14],"tags":[1137,1138,1139,1140],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/08\/oracletips.jpg?fit=650%2C361","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4397"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4397"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4397\/revisions"}],"predecessor-version":[{"id":4399,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4397\/revisions\/4399"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/4141"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4397"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}