RMAN Duplicate Corrupting Temp Files ORA-01187 ORA-01110
Last updated on JUNE 27, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
- 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms