ORA-00245 on alert_log.
Hi all,
I/m working with Oracle 11.2.0.2 on RAC.
Following this note 1268725.1 I change my controlfile autobackup destination to an ASM dg.
But I'm stil facing the error of the subject on one of the nodes.
Below, the entry on alert_log and an excerpt of the trace file:
Alert_log:
Thu Dec 23 18:27:55 2010
Control file backup creation failed.
Backup target file size found to be zero.
Errors in file /u01/app/oracle/diag/rdbms/wdm/wdm2/trace/wdm2_ckpt_29748.trc:
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Trace:
*** 2010-12-16 15:16:52.790
*** SESSION ID:(162.1) 2010-12-16 15:16:52.790
*** CLIENT ID:() 2010-12-16 15:16:52.790
*** SERVICE NAME:(SYS$BACKGROUND) 2010-12-16 15:16:52.790
*** MODULE NAME:() 2010-12-16 15:16:52.790
*** ACTION NAME:() 2010-12-16 15:16:52.790
Control file enqueue hold time tracking dump at time: 587905
1: 1118ms (rw) file: kct.c line: 1008 count: 1 total: 1118ms time: 587304
Control file enqueue hold time tracking dump at time: 595158
*** 2010-12-16 17:17:45.988
1: 1495ms (rw) file: kcrf.c line: 10003 count: 1 total: 1495ms time: 595150
2: 1118ms (rw) file: kct.c line: 1008 count: 1 total: 1118ms time: 587304
Control file enqueue hold time tracking dump at time: 596978
*** 2010-12-16 17:48:05.834
1: 1495ms (rw) file: kcrf.c line: 10003 count: 1 total: 1495ms time: 595150
2: 1118ms (rw) file: kct.c line: 1008 count: 1 total: 1118ms time: 587304
3: 510ms (rw) file: kcrf.c line: 9950 count: 1 total: 510ms time: 596549
Control file enqueue hold time tracking dump at time: 598838
*** 2010-12-16 18:19:05.303
1: 1962ms (rw) file: kcrf.c line: 9950 count: 9 total: 8612ms time: 597823
2: 1951ms (rw) file: kct.c line: 7782 count: 7 total: 6336ms time: 598538
3: 1495ms (rw) file: kcrf.c line: 10003 count: 1 total: 1495ms time: 595150
4: 1200ms (rw) file: kra.c line: 2298 count: 4 total: 3278ms time: 597956
5: 1129ms (ro) file: kcrr.c line: 3525 count: 2 total: 1828ms time: 597954
6: 1118ms (rw) file: kct.c line: 1008 count: 1 total: 1118ms time: 587304
7: 1017ms (rw) file: kcv.c line: 12293 count: 7 total: 4990ms time: 598355
8: 939ms (rw) file: kcffo.c line: 8340 count: 1 total: 939ms time: 598043
9: 550ms (rw) file: krse.c line: 1797 count: 1 total: 550ms time: 597960
10: 543ms (rw) file: kcv.c line: 12291 count: 1 total: 543ms time: 598477
Control file enqueue hold time tracking dump at time: 600723
Any suggestions?
(In order to be honest, I don't have a clue about where to start to understand this issue)
Thanks!