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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 | 추천 수 |
---|---|---|---|---|---|
12 | What’s in it for you? Attend Free MySQL Summit on March 23rd | 명품관 | 2023.03.09 | 285 | 0 |
11 | Introducing Oracle Database 23c Free – Developer Release [1] | 명품관 | 2023.04.04 | 799 | 0 |
10 | Oracle 23c의 JSON Relational Duality(JSON 관계형 이원성)의 주요 이점 | 명품관 | 2023.04.05 | 415 | 0 |
9 | What's new in Oracle Help Center Learn: March 2023 | 명품관 | 2023.04.11 | 404 | 0 |
8 | ADB Newsletter for April 2023 | 명품관 | 2023.04.11 | 446 | 0 |
7 | Oracle Database 23c Free Developer Release - 10 features you should know | 명품관 | 2023.04.13 | 375 | 0 |
6 | 오라클 April 2023 Critical Patch Update Released | 명품관 | 2023.04.19 | 530 | 0 |
5 | Oracle Database World 2023 - Watch the Replays | 명품관 | 2023.04.28 | 473 | 0 |
4 | Oracle GoldenGate Free 21c now available! | 명품관 | 2023.05.03 | 475 | 0 |
3 | PostgreSQL 16 Beta 2 Released! | 명품관 | 2023.06.30 | 511 | 0 |
2 | 6월에 Oracle Help Center에 등록된 튜토리얼 | 명품관 | 2023.07.18 | 397 | 0 |
1 | Oracle Database 23ai 발표: 정식 출시 | 명품관 | 2024.05.07 | 138 | 0 |