This content has been marked as final. Show 2 replies
6 start database using that pfile which says error in identifying control file(MY MISTAKE AS I HAVE NOT SO MUCH KNOWLEDGE ABOUT ASM)
now how can i get the information about latest control file which i have to use \alert.log lists all non-default parameters (including control_files) at every startup, search for an earlier startup an check the value of the parameter
The pfile should have *.control_file=<file1>, <file2>, etc..
If the db was open, show parameter control would work.
To answer the title of the post, how to delete files from asm:
I use dbca or rman for creating / restoring / destroying an instance. Sometimes, for various reasons, there may be an awful failure during one of those operations and then there are files strewn all over the asm diskgroup(s) not assinged to any instance. I manually remove those by setting oraenv to the asm instance, then entering the asmcmd command line. The commands are very similar to a bash shell; ls, ls -l and rm work well.