15 March 2011

ORA-16038: log 2 sequence# 2051 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 2 thread 1

[oracle@our12-appload ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Mar 14 12:46:06 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to an idle instance.

SQL>startup
ORACLE instance started.

Total System Global Area 1573527552 bytes
Fixed Size                  1300156 bytes
Variable Size             838863172 bytes
Database Buffers          721420288 bytes
Redo Buffers               11943936 bytes
Database mounted.
ORA-16038: log 2 sequence# 2051 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/oracle/db/10.2.0/oradata/
orcl/redo02.log'
--------------------------------------------------
 [oracle@our12-appload dbs]$ vi initorcl.ora
orcl.__db_cache_size=788529152
orcl.__java_pool_size=16777216
orcl.__large_pool_size=16777216
orcl.__shared_pool_size=1308622848
orcl.__streams_pool_size=0
*.audit_file_dest='/oracle/db/10.2.0/dbhome_1/admin/orcl/adump'
*.background_dump_dest='/oracle/db/10.2.0/dbhome_1/admin/orcl/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/oradata/orcl/control01.ctl','/oradata/orcl/control02.ctl','/oradata/orcl/control03.ctl'
*.core_dump_dest='/oracle/db/10.2.0/dbhome_1/admin/orcl/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='/oracle/db/10.2.0/dbhome_1/flash_recovery_area'
*.db_recovery_file_dest_size=1024967296
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/appload/archive'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=60000
*.pga_aggregate_target=1073741824
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=335
*.sga_target=2147483648

Solution :-
 I will changed the value

*.db_recovery_file_dest_size=4294967296


another method..
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=4294967296 SCOPE=BOTH;

SQL> shutdown abort
SQL> startup

No comments: