TAILIEUCHUNG - 7 Dealing with Database Corruption

After completing this lesson, you should be able to: • Identify the causes of database corruption: – Hardware – Software • Detect database corruption by using: – ANALYZE – DBVERIFY – DB_BLOCK_CHECKING – DBMS_REPAIR • Repair corruptions by using RMAN | Dealing with Database Corruption Objectives After completing this lesson, you should be able to: Identify the causes of database corruption: Hardware Software Detect database corruption by using: ANALYZE DBVERIFY DB_BLOCK_CHECKING DBMS_REPAIR Repair corruptions by using RMAN What Is Block Corruption? Whenever a block is read or written, a consistency check is performed. Block version DBA (data block address) value in cache as compared to the DBA value in the block buffer Block-checksum, if enabled A corrupt block is identified as being one of the following: Media corrupt Logically (or software) corrupt What Is Block Corruption? A corrupted data block is a block that is not in a recognized Oracle format, or whose contents are not internally consistent. Typically, corruptions are caused by faulty hardware or operating system problems. The Oracle database identifies corrupt blocks as either “logically corrupt” or “media corrupt.” If it is logically corrupt, then there is an Oracle internal error. Logically corrupt blocks are marked corrupt by the Oracle database after it detects the inconsistency. If it is media corrupt, then the block format is not correct; the information in the block does not make any sense after being read from disk. You can repair a media corrupt block by recovering the block or dropping the database object that contains the corrupt block, or both. If media corruption is due to faulty hardware, the problem will not be completely resolved until the hardware fault is corrected. Block Corruption Symptoms: ORA-01578 The error ORA-01578: "ORACLE data block corrupted (file # %s, block # %s)": Is generated when a corrupted data block is found Always returns the absolute file number and block number Is returned to the session that issued the query being performed when the corruption was discovered Appears in the file Block Corruption Symptoms: ORA-01578 Usually, the ORA-01578 error is the result of a hardware problem. If the ORA-01578 error is

TÀI LIỆU LIÊN QUAN
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.