1 / 2
文档名称:

ORACLE10G更改归档日志空间大小.doc

格式:doc   页数:2页
下载后只包含 1 个 DOC 格式的文档,没有任何的图纸或源代码,查看文件列表

如果您已付费下载过本站文档,您可以点这里二次下载

分享

预览

ORACLE10G更改归档日志空间大小.doc

上传人:xxj16588 2016/5/6 文件大小:0 KB

下载得到文件列表

ORACLE10G更改归档日志空间大小.doc

相关文档

文档介绍

文档介绍:ORACLE10G 更改归档日志空间大小 Hi, I'm getting the following error message when starting up the database: OS: SUN Solaris DB: USING ASM SQL> startup ORACLE instance started. Total System Global Area 2634022912 bytes Fixed Size 2130720 bytes Variable Size 513637600 bytes Database Buffers 2113929216 bytes Redo Buffers 4325376 bytes Database 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/' ORA-00312: online log 2 thread 1: '+SHARED_DATA_DG03/proddb/onlinelog/' I couldn't figure out what to do. I even deleted all the archivelogs from RMAN: RMAN> delete noprompt archivelog all; released channel: ORA_DISK_1 released channel: ORA_DISK_2 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=64 devtype=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: sid=163 devtype=DISK specification does not match 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_FRA_DG01 db_recovery_file_dest_size big integer 2G recovery_parallelism integer 0 After checking this, I knew what my problem was. The db_recovery_file_dest_size is set to 2G. When i