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
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 | 추천 수 |
---|---|---|---|---|---|
10 | MySQL Database Service (in Oracle Cloud Infrastructure) | 명품관 | 2021.02.04 | 16784 | 0 |
9 | Time-out and Thanks by Tom Kyte (Tom Kyte 의 휴식) | 명품관 | 2016.01.08 | 20906 | 0 |
8 | Watch featured OTN Virtual Technology Summit Replay Sessions - Nov 30, 2015 | 명품관 | 2015.12.01 | 31229 | 0 |
7 | Oracle Magazine Junary/February 2019 | 명품관 | 2019.03.12 | 40115 | 0 |
6 | Oracle Database 19c 다운로드 가능 | 명품관 | 2019.04.30 | 59706 | 0 |
5 | 오라클 18c Express Edition(XE) 윈도우 버전 사용 가능 | 명품관 | 2019.02.22 | 64448 | 0 |
4 | MOATS: The Mother of All Tuning Scripts! (by TANEL PODER) | 명품관 | 2016.04.28 | 83767 | 0 |
» | MOS Note:136697.1 - New HCHECK.SQL for Oracle Database 12c | 명품관 | 2016.06.01 | 119599 | 0 |
2 | Announcing the general availability of Oracle Linux 7.2 | 명품관 | 2015.11.30 | 187464 | 0 |
1 | MariaDB 10.4.2 Beta Release | 명품관 | 2019.02.01 | 353040 | 0 |