加强心理咨询网站的建设方案,网站项目怎么做,江苏省城乡建设部网站首页,公司网站与营销网站在栏目上的不同提示ORA-03113#xff1a;通信通道的文件结尾解决事情原由#xff1a;oracle安装到win7下#xff0c;以为都是直接sqlplus / as sysdba#xff0c;使用数据库#xff0c;但最近连接时频繁报错#xff0c;提示ORA-03113#xff1a;通信通道的文件结尾进程 ID #xff1a…提示ORA-03113通信通道的文件结尾解决事情原由oracle安装到win7下以为都是直接sqlplus / as sysdba使用数据库但最近连接时频繁报错提示ORA-03113通信通道的文件结尾进程 ID 6988回话 ID191 序列号3第一步123456789sqlplus / assysdbashutdown abortstartup mountSQL show parameterbackground_dump_dest;NAME TYPE VALUE------------------------------------ -----------------------------------------background_dump_dest string d:\app\baoshengzhu\diag\rdbms\oracle\oracle\trace进入该路径查看alert_oracle.log可见文件记录错误如下####################错误信息以及建议解决的方法##########################################################Errors in filed:\app\baoshengzhu\diag\rdbms\oracle\oracle\trace\oracle_ora_6988.trc:ORA-19815: 警告: db_recovery_file_dest_size 字节 (共 4102029312 字节)已使用 100.00%, 尚有 0 字节可用。************************************************************************You have following choices to free up space from recoveryarea:1. Consider changing RMAN RETENTION POLICY. If you are usingData Guard,then consider changingRMAN ARCHIVELOG DELETION POLICY.2. Back up files to tertiary device such as tape usingRMANBACKUP RECOVERY AREAcommand.3. Add disk space and increase db_recovery_file_dest_sizeparameter toreflect the newspace.4. Delete unnecessary files using RMAN DELETE command. If anoperatingsystem command was usedto delete files, then use RMAN CROSSCHECK andDELETE EXPIREDcommands.12345678910111213###################################################################################第二步select * fromv$recovery_file_dest;alter system setdb_recovery_file_dest_size10737418240---这里是改为10G。alter databaseopenexit第三步进入rman工具窗口rman target /RMANcrosscheck archivelogall; --运行这个命令可以把无效的expired的archivelog标出来。RMANdelete expiredarchivelog all; --直接全部删除过期的归档日志。RMANdelete nopromptarchivelog until time sysdate-3; --也可以直接用一个指定的日期来删除。重新打开数据库正常使用
