Removing the datafiles from ASM

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Removing the datafiles from ASM

nauman
Dear Erman,

I am having space issues on ASM one of my instance,  on investigating i come to know that some datafiles are present on the ASM which belongs to some previous database which is currently not running. So i need to delete these obsolete files. Can you please guide me how to do it.

Thanks & Regards
Reply | Threaded
Open this post in threaded view
|

Re: Removing the datafiles from ASM

ErmanArslansOracleBlog
Administrator
Well, you will find and delete them.

following Oracle Support document will help you ->

Script to report the list of files stored in ASM and CURRENTLY NOT OPENED (Doc ID 552082.1)
Query That Can Be Used to Find Orphaned Datafiles on a 12c ASM Instance (Doc ID 2228573.1)