怎么回事 问大家一下为什么我的数据库改为归档模式之后plsql和sqlplus都登陆不上去啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 alert log 里面有什么错误没有?$ORACLE_BASE\admin\sid\bdump\alert.log------------------------------------------------------------------------------ Blog: http://blog.csdn.net/tianlesoftware 网上资源: http://tianlesoftware.download.csdn.net 相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 群:62697716(满); DBA2 群:62697977DBA3 群:63306533; 聊天 群:40132017 You have the following choices to free up space fromflash recovery area:1. Consider changing your RMAN retention policy. If you are using dataguard, then consider changing your RMAN archivelog deletion policy.2. Backup files to tertiary device such as tape using the RMAN command BACKUP RECOVERY AREA.3. Add disk space and increase the db_recovery_file_dest_size parameter to reflect the new space.4. Delete unncessary files using the RMAN DELETE command. If an OS command was used to delete files, then use RMAN CROSSCHECK and DELETE EXPIRED commands.*************************************************************Mon Jul 12 10:27:14 2010Errors in file g:\oracle\product\10.1.0\admin\demo\bdump\demo_arc0_2340.trc:ORA-19809: limit exceeded for recovery filesORA-19804: cannot reclaim 9954304 bytes disk space from 2147483648 limitARC0: Error 19809 Creating archive log file to 'G:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\DEMO\ARCHIVELOG\2010_07_12\O1_MF_1_1077_U_.ARC'ARC0: All standby destinations failed; successful archival assumedARC0: Failed to archive log 4 thread 1 sequence 1077 (19809)ARCH: Archival stopped, error occurred. Will continue retryingARCH: Mon Jul 12 10:27:14 2010ORA-16038: log 4 sequence# 1077 cannot be archivedORA-19809: limit exceeded for recovery filesORA-00312: online log 4 thread 1: 'C:\123.LOG'ORA-00312: online log 4 thread 1: 'C:\111.LOG'Mon Jul 12 10:27:14 2010Errors in file g:\oracle\product\10.1.0\admin\demo\bdump\demo_arc0_2340.trc:ORA-16038: log 4 sequence# 1077 cannot be archivedORA-19809: limit exceeded for recovery filesORA-00312: online log 4 thread 1: 'C:\123.LOG'ORA-00312: online log 4 thread 1: 'C:\111.LOG'Mon Jul 12 10:27:29 2010ARC1: Evaluating archive log 4 thread 1 sequence 1077ARC1: Archiving not possible: No primary destinationsARC1: Failed to archive log 4 thread 1 sequence 1077 (4)ARCH: Archival stopped, error occurred. Will continue retryingARCH: Mon Jul 12 10:27:30 2010ORA-16014: log 4 sequence# 1077 not archived, no available destinationsORA-00312: online log 4 thread 1: 'C:\123.LOG'ORA-00312: online log 4 thread 1: 'C:\111.LOG'Mon Jul 12 10:27:30 2010Errors in file g:\oracle\product\10.1.0\admin\demo\bdump\demo_arc1_2344.trc:ORA-16014: log 4 sequence# 1077 not archived, no available destinationsORA-00312: online log 4 thread 1: 'C:\123.LOG'ORA-00312: online log 4 thread 1: 'C:\111.LOG'这是log里的信息 你的闪回区满了....参考...http://space.itpub.net/8334342/viewspace-510238 1.打开oralce安装目录下的flash_recovery_area/对应sid/archivelog目录,删除较老的日志文件。也可以SELECT * FROM v$archived_log查看日志文件位置。2.rman target sys@sid,输入密码后登陆.3.登陆后执行crosscheck archivelog all;检查已经失效的日志文件然后执行 delete expired archivelog all;删除已失效的日志文件。4.重启数据库 想创建一个带输出结果集的过程出现问题 oracle数据库取随即记录时出错 跪求解决方案 ORACLE exp的问题 oracle em不能打开,建立的用户连接就卡在那里 急!!!ias server群集问题 一个关于存储过程的问题急啊~~!高手请帮帮我! oracle 触发器修改触发事件的表的另一字段 接着问,接着昨天的话题,^_^ 有什么命令可以知道对一句sql的编译是否能够通过,而不去执行这sql? Oracle805的Utl_raw.bit_or是否存在问题,谁能解释? sqlldr问题 Mysql分页存储过程改为Oracle分页存储过程
alert log 里面有什么错误没有?$ORACLE_BASE\admin\sid\bdump\alert.log
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
DBA3 群:63306533; 聊天 群:40132017
flash recovery area:
1. Consider changing your RMAN retention policy.
If you are using dataguard, then consider changing your
RMAN archivelog deletion policy.
2. Backup files to tertiary device such as tape using the
RMAN command BACKUP RECOVERY AREA.
3. Add disk space and increase the db_recovery_file_dest_size
parameter to reflect the new space.
4. Delete unncessary files using the RMAN DELETE command.
If an OS command was used to delete files, then use
RMAN CROSSCHECK and DELETE EXPIRED commands.
*************************************************************
Mon Jul 12 10:27:14 2010
Errors in file g:\oracle\product\10.1.0\admin\demo\bdump\demo_arc0_2340.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 9954304 bytes disk space from 2147483648 limitARC0: Error 19809 Creating archive log file to 'G:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\DEMO\ARCHIVELOG\2010_07_12\O1_MF_1_1077_U_.ARC'
ARC0: All standby destinations failed; successful archival assumed
ARC0: Failed to archive log 4 thread 1 sequence 1077 (19809)
ARCH: Archival stopped, error occurred. Will continue retrying
ARCH:
Mon Jul 12 10:27:14 2010
ORA-16038: log 4 sequence# 1077 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 4 thread 1: 'C:\123.LOG'
ORA-00312: online log 4 thread 1: 'C:\111.LOG'Mon Jul 12 10:27:14 2010
Errors in file g:\oracle\product\10.1.0\admin\demo\bdump\demo_arc0_2340.trc:
ORA-16038: log 4 sequence# 1077 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 4 thread 1: 'C:\123.LOG'
ORA-00312: online log 4 thread 1: 'C:\111.LOG'Mon Jul 12 10:27:29 2010
ARC1: Evaluating archive log 4 thread 1 sequence 1077
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive log 4 thread 1 sequence 1077 (4)
ARCH: Archival stopped, error occurred. Will continue retrying
ARCH:
Mon Jul 12 10:27:30 2010
ORA-16014: log 4 sequence# 1077 not archived, no available destinations
ORA-00312: online log 4 thread 1: 'C:\123.LOG'
ORA-00312: online log 4 thread 1: 'C:\111.LOG'Mon Jul 12 10:27:30 2010
Errors in file g:\oracle\product\10.1.0\admin\demo\bdump\demo_arc1_2344.trc:
ORA-16014: log 4 sequence# 1077 not archived, no available destinations
ORA-00312: online log 4 thread 1: 'C:\123.LOG'
ORA-00312: online log 4 thread 1: 'C:\111.LOG'
这是log里的信息
参考...http://space.itpub.net/8334342/viewspace-510238
也可以SELECT * FROM v$archived_log查看日志文件位置。
2.rman target sys@sid,输入密码后登陆.
3.登陆后执行crosscheck archivelog all;检查已经失效的日志文件
然后执行 delete expired archivelog all;删除已失效的日志文件。
4.重启数据库