Friday, May 02, 2008

ORA-19504: failed to create file

SQL> startup
ORACLE instance started.

Total System Global Area 1620115456 bytes
Fixed Size 2144864 bytes
Variable Size 1207960992 bytes
Database Buffers 402653184 bytes
Redo Buffers 7356416 bytes
Database mounted.
ORA-16038: log 2 sequence# 302 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 2 thread 1:
'+DATA/testdb/onlinelog/group_2.1080.651074461'
ORA-00312: online log 2 thread 1:
'+DATA/testdb/onlinelog/group_2.1079.651074465'


=> Check Disks for Archivelog

This case used ASM (on +DATA):

$ export ORACLE_SID=+ASM
$ sqlplus / as sysdba

set lines 130
set pages 10000
select NAME, TOTAL_MB, FREE_MB from v$asm_diskgroup;

NAME TOTAL_MB FREE_MB
----------- ---------- ----------
DATA 7812 0

=> Clear Archivelog by using RMAN
(delete archivelog all, delete archivelog until time 'xxxx')

>>>

NAME TOTAL_MB FREE_MB
------------ ---------- ----------
DATA 7812 1627
>>>

After that, we can database instance.

SQL> alter database open

Database altered.

...

No comments: