Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
TDE Database Restore Failure

Platform: AIX 7.1
Oracle version: 18c
Source database: TDB database with Auto Login wallet
Both cwallet.sso and ewallet.p12 files are copied over to target server prior to the restore.
During restore, it is confirmed that wallet is open on target server with Auto Login.
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS WALLET_TYPE
------------------------------ --------------------
/<OS_path>/wallet/
OPEN AUTOLOGIN
Steps taken to restore:
- Enable TDE and configure Auto Login wallet
- Take incremental backup
- Take archivelog backup
- copy wallet files to target server
- Restore TDE database on target server
Restore fails when executing command "alter database open resetlogs;". Error is below.
ORA-28420: cannot open resetlogs from a restore point prior to wallet creation
ORA-01110: data file 1: '/<OS_path>/system01.dbf'
If I manually re-create the controlfile, the error goes away and restore is successful.
ORA-28420 error seems misleading here as the backup is taken after wallet creation. What happened here?
Appreciate any pointers.