ORA-1578 Corrupt Block Found in Encrypted Database (Doc ID 1329437.1)

rongshiyuan發表於2014-03-22
BloCDatabase
ORA-1578 Corrupt Block Found in Encrypted Database (Doc ID 1329437.1)

In this Document

Symptoms
Changes
Cause
Solution
References


Applies to: 

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms


ORA-1578 Encrypted database cloned with RMAN and opened with incorrect wallet or other database wallet shows corruption.

DBV and RMAN do not show any corruption.
The dump of the corrupted blocks shows the blocks are soft-corrupted in memory: seq:0xff.

To make sure the blocks are good on disk run dbv for the associated datafile or block (dbv with START/END clauses).

Changes


When an encrypted database is created using TDE, two files are created and used with the encryption process: cwallet.sso and ewallet.p12.
The location of these files is in the sqlnet.ora provided by ENCRYPTION_WALLET_LOCATION.

If by mistake an encrypted database is opened using incorrect wallet or other database wallet, ORA-1578 can be reported because of soft corupted blocks in memory.

Cause


Encrypted database opened with incorrect wallet.

Solution


Open encrypted database using the correct wallet.

References

BUG:12313488 - CORRUPT BLOCK AFTER RESTORING BACKUP OF AN ENCRYPTED DATABASE

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1127488/，如需轉載，請註明出處，否則將追究法律責任。

相關文章