oracle安装设置归档空间大小,ORACLE10G更改归档日志空间大小

ORACLE10G更改归档日志空间大小

Hi,

I'm getting the following error message when st arting up the database:

OS: SUN Solaris 5.10 DB: 10.2.0.3 USING ASM

SQL> st artup

ORACLE instance st arted.

Total Syst em Global Area 2634022912 byt es

Fixed Size 2130720 byt es

Variable Size 513637600 byt es

Dat abase Buffers 2113929216 byt es

Redo Buffers 4325376 byt es

Dat abase mounted.

ORA-16038: log 2 sequence# 1704 cannot be archived

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 2 thread 1:

'+SHARED_DATA_DG02/proddb/onlinelog/group_2.257.681318315'

ORA-00312: online log 2 thread 1:

'+SHARED_DATA_DG03/proddb/onlinelog/group_2.263.681321803'

I couldn't figure out what to do. I even delet ed all the archivelogs from RMAN: RMAN> delete noprompt archivelog all;

released channel: ORA_DISK_1

released channel: ORA_DISK_2

allocat ed channel: ORA_DISK_1

channel ORA_DISK_1: sid=64 devtype=DISK

allocat ed channel: ORA_DISK_2

channel ORA_DISK_2: sid=163 devtype=DISK

specification does not mat ch any archive log in the recovery catalog

I then checked the recovery area:

SQL> show parameter recovery

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest string +SHARED_F RA_DG01