Tuesday, March 25, 2008

ORA-16038,ORA-19809,ORA-00312

ORA-16038: log 3 sequence# 6180 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/home/oracle/XXXDB/redo03.log'

SQL> set lines 100
col name format a60
select  name
,       floor(space_limit / 1024 / 1024) "Size MB"
,       ceil(space_used  / 1024 / 1024) "Used MB"
SQL> SQL>   2    3    4  from   v$recovery_file_dest
order by name  5
  6  ;

NAME                                                            Size MB    Used MB
------------------------------------------------------------ ---------- ----------
/home/oracle/db/flash_recovery_area                              256000     255976

SQL> alter system set db_recovery_file_dest_size=6399400 m scope=both;


System altered.


SQL> select  name,
floor(space_limit / 1024 / 1024) "Size MB",
ceil(space_used  / 1024 / 1024) "Used MB"
from   v$recovery_file_dest  2
order by name   3    4    5
  6  ;


NAME                                                            Size MB    Used MB
------------------------------------------------------------ ---------- ----------
/home/oracle/db/flash_recovery_area                             6399400     256058


SQL> alter database open;


Database altered.

No comments:

Post a Comment