Skip to Main Content

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!

Controlfile not present in ASM

user13420250Dec 10 2012 — edited Dec 13 2012
Hi,

in our backup logfile we see the follwoing error (db 11.2.0.1.0 64 bit)

RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 12/10/2012 01:46:31
ORA-19504: failed to create file "+FRA/ngp01/controlfile/c-1446976194-20121210-02"
ORA-17502: ksfdcre:4 Failed to create file +FRA/ngp01/controlfile/c-1446976194-20121210-02
ORA-15173: entry 'ngp01' does not exist in directory '/'

I have checked and the ngp01 directory does not exist in ASM.
But whats also strange..
When checking the v$controlfile, I see the following:

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
+FRA/ngp01/controlfile/current.3434.796827271


Same directory that does not exist according to RMAN and also can't be seen by me using asmcmd.
So, how come the database is still running ?
I was also able to create a backup to trace from this controlfile, and the backup looks good. Everything mentioned in the file is correct.
So, it seems the db thinks the controlfile is still available, but it's not !
Could it be, the controlfile is cached by ASM or something like that ? And what is the db updating if there is no controlfile to update ?
There are no errors in the alert.log of the database.
Anyone who has seen this before ?

Thnx !
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 10 2013
Added on Dec 10 2012
17 comments
3,070 views