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 laterInformation 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to Collect Diagnostics for Database Hanging Issues (Doc ID 452358.1)Database
- [轉帖]Release Schedule of Current Database Releases (Doc ID 742060.1)Database
- Oracle 最新PSU (Doc ID 2118136.2)Oracle
- -bash: id: command not found -bash: tty: command not found
- expdp/impdp變慢 (Doc ID 2469587.1)
- Reading and Understanding Systemstate Dumps (Doc ID 423153.1)
- SUPTOOL: BBED - 7.3.2+ Database Block Editor(轉)DatabaseBloC
- RMAN -- Frequently Asked Question (FAQ) (Doc ID 469777.1)
- Oracle 下載最新psu (Doc ID 2118136.2)Oracle
- PRCT-1011 : Failed to run "oifcfg" (Doc ID 1380183.1)AI
- 【CURSOR】How to Monitor and tune Open and Cached Cursors (Doc ID 1430255.1)
- Migration Of An Oracle Database Across OS Platforms [ID 733205.1]OracleDatabaseROSPlatform
- rfs (PID:146054): Database mount ID mismatch案例Database
- Plugin with id 'com.android.application' not found.PluginAndroidAPP
- bash: ssh-copy-id: command not found...
- Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)
- oracle11g: Scheduler Maintenance Tasks or Autotasks (Doc ID 756734.1)OracleAINaN
- 【DBA】Relinking Oracle Home 常見問題 (Doc ID 2048232.1)Oracle
- How To Replicate Data from Oracle to Postgres Using GoldenGate (Doc ID 1544137.1OracleGo
- 11g-Reduce Transportable Tablespace Downtime using XTTS (Doc ID 1389592.1)TTS
- Can GoldenGate Replicate An Oracle Table That Contains Only CLOB Column(s)? (Doc ID 971833.1)GoOracleAI
- 12c DG新特性 - Active Data Guard Far Sync (Doc ID 2179719.1)
- 【GRID】Grid Infrastructure 啟動的五大問題 (Doc ID 1526147.1)ASTStruct
- 【DATAGUARD】Data Guard 12C 新特性:Far Sync Standby (Doc ID 2179719.1)
- ORA-04063: package body SYS.DBMS_REGISTRY_SYS has errors (Doc ID 2165402.1)PackageError
- 【ASM】ORA-27504 ORA-27300 ORA-27303 while starting ASM (Doc ID 2281441.1)ASMWhile
- 【RAC】Oracle 12c以及以上版本的diagsnap是什麼? (Doc ID 2469643.1)Oracle
- ORA-02062: distributed recovery 引起的 ORA-02019: connection description for remote database not foundREMDatabase
- sqlserver docSQLServer
- TENSEAL: A LIBRARY FOR ENCRYPTED TENSOR OP- ERATIONS USING HOMOMORPHIC ENCRYPTION 解讀
- ORA-19599 When Backing up an Archivelog that is CorruptHive
- 打 patch 報錯:corrupt patch at line 36
- BlockBloC
- Block學習①--block的本質BloC
- Unused Block Compression和Null Block CompressionBloCNull
- __block使用BloC
- Block學習②--block的變數捕獲BloC變數
- iOS block巢狀block中weakify的使用iOSBloC巢狀
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST