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.
...
Friday, May 02, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment