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.
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/
[oracle@our12-appload dbs]$ vi initorcl.oraorcl/redo02.log'
--------------------------------------------------
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> shutdown abort
SQL> startup
No comments:
Post a Comment