oracle闪回恢复区问题

《oracle闪回恢复区问题》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、3.无法连接到数据库(麻醉客户端，plsql等)2010-07-2623：30现象：出现问题吋I'n]2010-07-2623：30之前都正常操作，21点左右都还在正常用。报出的错误:最初出现这个问题时报错如下图:当时看到问题，我以为在做备份数据库，之后大概1小时过后仍有这个问题,问题原因：闪存恢复区(flash_recover_area)空间已满。数据库开启的自动归档模式，归档日志将闪存恢复区儿乎占满。^HQL>connectassysdba■应臭音用芦名:sys^HQL>archiveI09list；・••希1式nrcnlirRVpivfnrcT■沖m七甘卜和汨主序可.QL>■112JTE

2、WWJCn1J"11/C1

3、cTC：YIMD0YSsysteB32cBd.exe-sqlplus/nolog^■C~nTISP2-0640：未连接

4、SQL>connectsys/mdsdassysdba己连接。SQL>select*fromu$log；GROUP#THREADttSEQUENCE#BYTESMEMBERSARCSTATUSFIRST^CHANGEttFIRST」IME111453524288001NOCURRENT7149275826-?月-10311452524288001NOINACTIUE7141512626-7月-10211451524288001NOINACTI

5、UE7136511526-？月-10SQL>select*fronu$recouevy_file._dest；NAMESPACEJLIMITSPfiCE_USEDSPACEJECLAIMABLENUMBER^OFJILESD:oracleproduct10•2.0flash_i*ecouery_area2147483648211480422444SQL>select*fromu$flash_i'ecouery_area-.usage；FILE_TYPEPERCENT_SPACE_USEDPERCENT_SPACEJECLAIMABLENUMBER_OFJILESCONTROLFILEO

6、NLINELOGARCHIUELOGBACKUPPIECEIMAGECOPVFLASHBACKLOG0098.48a000000000044000己选择6行。SQL>SQL>connectsys/mdsdassysdba已连接。SQL>select*fromv$log;GROUP#THREAD#SEQUENCE#BYTESMEMBERSARCSTATUSFIRST_CHANGE#FIRST_T1ME11453524288001NOCURRENT7149275826-7月-10311452524288001NOINACTIVE7141512626-7月-10211451524288001NOIN

7、ACTIVE7136511526-7月-10SQL>select*fromv$recovery_file_dest;NAMESPACE_LIMITSPACE_USEDSPACE_RECLAIMABLENUMBER_OF_FILESD:oracleproductl0.2.0flash_recovery_area4421474836482114804224SQL>select*fromv$flash_recovery_area_usage;FILE.TYPEPERCENT_SPACE_USEDPERCENT_SPACE_RECLAIMABLENUMBER_OF_FILESCONTROLFI

8、LE000ONLINELOG000ARCHIVELOG98.48044BACKUPPIECE000IMAGECOPY000FLASHBACKLOG000己选择6行。解决方案将闪回恢复区取消。SQL>SQL>SQL>selectlog_modefromv$database;LOG_MODENOARCHIVELOGSQL>shutdownimmediate;数据库已经关闭。已经卸载数据库。ORACLE例程已经关闭。SQL>startupmountORACLE例程已经启动。TotalSystemGlobalArea1258291200bytesFixedSizeVariableSizeDatabas

9、eBuffersRedoBuffers数据库装载完毕。2065408bytes318770176bytes922746880bytes14708736bytesSQL>showparameterrecoveryNAMETYPEVALUEstringbiginteger2Gdb_recovery_fi1e_destdbrecoveryfiledestsizerecovery_parallelismi