메뉴 건너뛰기

검색창 닫기

Korea Oracle User Group

새소식

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

명품관 2016.06.01 14:52 조회 수 : 119610

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

, , , , , 이 게시물을
목록
번호 제목 글쓴이 날짜 조회 수 추천 수
50 VirtualBox 6.1.4 Released!! 명품관 2020.02.21 431 0
49 Oracle 23c의 JSON Relational Duality(JSON 관계형 이원성)의 주요 이점 명품관 2023.04.05 422 0
48 Oracle Exadata X10M 발표, Exadata Cloud@Customer X10M 발표 소식입니다 명품관 2023.06.28 422 0
47 What's new in Oracle Help Center Learn: March 2023 명품관 2023.04.11 421 0
46 2023년 5월 오라클 Help Center Learn의 튜토리얼과 labs 명품관 2023.06.13 417 0
45 MariaDB Enterprise Server 10.6.5-2, and others, now available file 명품관 2021.12.22 414 0
44 6월에 Oracle Help Center에 등록된 튜토리얼 명품관 2023.07.18 409 0
43 Oracle Enterprise Manager 13c Release 5 Update 21 (13.5.0.21) 명품관 2024.04.08 407 0
42 MariaDB 11.2.0 preview release available 명품관 2023.06.27 402 0
41 MariaDB ODBC Connector 3.1.18 now available 명품관 2023.04.18 401 0
40 Exadata System Software Updates - March 2023 명품관 2023.03.09 399 0
39 PostgreSQL 15.3, 14.8, 13.11, 12.15, and 11.20 Released! 명품관 2023.05.18 399 0
38 MariaDB C Connector 3.3.5 and 3.1.21 now available 명품관 2023.05.25 399 0
37 MariaDB Python Connector 1.1.6 now available 명품관 2023.03.09 398 0
36 pgAdmin 4 v6.21 Released 명품관 2023.03.14 398 0
35 Oracle Enterprise Manager 13c Release 5 Update 14 (13.5.0.14) is now available 명품관 2023.04.11 398 0
34 MariaDB Java Connector 3.1.4 now available 명품관 2023.05.03 393 0
33 Oracle Critical Patch Update Advisory - January 2024 명품관 2024.01.17 393 0
32 MariaDB Community Server 11.0 GA and 11.1 RC 릴리즈 소식 명품관 2023.06.07 392 0
31 Oracle Developer Day(2022년 1월 19일(수)) 명품관 2021.12.23 389 0
쓰기 태그
위로