메뉴 건너뛰기

Korea Oracle User Group

새소식

MOS Note:136697.1 - New HCHECK.SQL for Oracle Database 12c

By Mike Dietrich-Oracle on May 19, 2016

 

A while back we added this slide to our big slide deck:

 

 

The story behind this slide

 

A large and important customer in the US tested a patch set upgrade - but when they approached the production upgrade from 11.2.0.2 to 11.2.0.3 on a large RAC cluster they've had to cancel the attempt and revert to the previous state.

 

Reason

 

They've hit a dictionary corruption somewhere silently sleeping in the database causing no trouble at all so far - until the upgrade touched the broken structures 

They've asked us:
"How could we ensure the database is really healthy and in good state?"

And unfortunately there's no 100% confirmation as there may be an unknown issue we are not aware of. But we can test two things:

 

  • Let RMAN verify the logical integrity of the Oracle blocks
  • Let the hcheck.sql script provided by Oracle Support check and test for known dictionary issues

 

It's actually a general recommendation we give to customers for a long time to check their really important and business critical databases from time to time during off-peak hours. 

 

Recently Oracle Support updated hcheck.sql to version 4 to include Oracle Database 12c checks as well.

Please find it here:

 

 

출처 : https://blogs.oracle.com/UPGRADE/entry/new_hcheck_sql_for_oracle

번호 제목 글쓴이 날짜 조회 수 추천 수
47 Oracle Database 12c Release 2 Linux x86-64 Released [2] 명품관 2017.03.02 1132 0
46 Oracle Database 12.2 Release 스케줄 정보 [1] 명품관 2017.02.01 555 0
» MOS Note:136697.1 - New HCHECK.SQL for Oracle Database 12c 명품관 2016.06.01 119024 0
44 DMU - Tips and Tricks - Migration Assistant for Unicode 명품관 2016.05.31 2257 0
43 Oracle Database Migration Assistant for Unicode(DMU) 명품관 2016.05.31 4005 0
42 오라클 Webcast 일정입니다. 참고해서 등록하세요~ file 명품관 2016.05.20 2452 0
41 OTN Virtual Technology Summit Replay Libraries 명품관 2016.05.11 1189 0
40 MS, SQL서버2016 다음달 1일 출시 [1] 명품관 2016.05.04 1281 0
39 Windows Subsystem for Linux Overview 명품관 2016.05.04 672 0
38 MOATS: The Mother of All Tuning Scripts! (by TANEL PODER) 명품관 2016.04.28 83337 0
37 SQL Dashboard – V2 명품관 2016.04.27 834 0
36 eDB360 - Carlos Sierra's Tools(SQLTXPLAIN 개발자) 명품관 2016.04.25 1667 1
35 New! Announcing MySQL Enterprise Transparent Data Encryption 명품관 2016.04.23 6007 0
34 Complete list of new features in MySQL 5.7 명품관 2016.04.22 1550 0
33 Oracle Berkeley Database (BDB) 6.2 Announced 명품관 2016.04.21 2182 0
32 RACSIG에서 구글 이벤트를 통해 Load-Balancing a RAC Database 타이틀로 webinar 진행합니다. 명품관 2016.04.20 1973 0
31 VirtualBox 5.0.18 (released 2016-04-18) 명품관 2016.04.20 1411 0
30 2016년 Oracle Open World 소식 file 명품관 2016.04.15 456 0
29 올해 차세대시스템 발주 봇물…금융IT 시장 승자는 누구? 명품관 2016.04.08 361 0
28 "파격은 없었다”…카카오뱅크, 기간계 DBMS로 오라클 결정 명품관 2016.04.07 540 0
위로