Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to remove non-existing tempfile

V PJSMar 8 2017 — edited Mar 9 2017

Hi,

I duplicated one of our database from ASM to normal file system in another server using Rman,

after duplication, the tempfile became '+DATA' only and it keep prompting error

ORA-01110: data file 1025: '+DATA'

When I tried to drop the tempfile, the same error also prompting.

Any one know how to remove this non-existing tempfile?

Thanks

Vincent

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2017

Added on Mar 8 2017

#performance-availability, #recovery-manager-rman

3 comments

897 views