Wednesday, March 18, 2009

ORA 16038,19809,00312

Db error due to shutdown abort :
ORA-16038: log 2 sequence# 450 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/mnt/app/oracle/db/data/orcl/redo02.log'

=>sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Mar 18 14:38:05 2009
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
SQL> conn / as sysdba
Connected.
SQL> startup mount;
SQL> show parameter DB_RECOVERY_FILE_DEST_SIZE
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 2G




SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE = 10g;
System altered.

[ If space is not available you can delete some files from flash recovery area. ]
SQL> shutdown immediate;
Database dismounted.
ORACLE instance shut down.


SQL> startup;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size                  2058616 bytes
Variable Size             486540936 bytes
Database Buffers         1107296256 bytes
Redo Buffers               14716928 bytes
Database mounted.
Database opened.

No comments:

Post a Comment