RMAN Duplicate Corrupting Temp Files ORA-01187 ORA-01110
(Doc ID 2250889.1)
Last updated on AUGUST 22, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Rman duplicate completes without any error. Select or any Sort operation which uses tempfile fails with ORA-01187 or ORA-01110
- Files from Previous Rman duplicate still present.
- There is a requirement to do Rman duplicate using standard scripts every day to the auxiliary instance. Script uses a fix name for the tempfiles
- Prod and auxiliary on separate server but having same directory structure and on filesystem.
The purpose of this document is list various workarounds that can be used to Prevent this issue from Happening.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
Applies to: |
References |