Tue Jan 22 15:56:19 2013
Errors in file f:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_arc0_2804.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4039114752 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Errors in file f:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_arc0_2804.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 42408960 bytes disk space from 4039114752 limit
ARC0: Error 19809 Creating archive log file to 'F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2013_01_22\O1_MF_1_97_%U_.ARC'
这是警告日志中内容
Errors in file f:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_arc0_2804.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4039114752 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Errors in file f:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_arc0_2804.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 42408960 bytes disk space from 4039114752 limit
ARC0: Error 19809 Creating archive log file to 'F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2013_01_22\O1_MF_1_97_%U_.ARC'
这是警告日志中内容
解决方案 »
- orale sql 语句问题!!
- OracleParameter 参数问题
- oracle客户端和服务端的问题
- 求多条记录合并sql写法
- 再次请教chliang315()~~~(急):sql 查询多条数据时字段id的值是不为一的,但是我要取出id是唯一的多条数据,谢谢
- java 连接 oracle 之ClassNotFoundEXception
- oracle有没有integer类型,这种类型的最大值是多少啊?
- 高手请指教:ora-00984.列不允许。是什么问题。(在线等待)
- ORACLE数据库的字符集的修改????
- sql 查询 [Err] ORA-00907: 缺失右括号
- ORACLE dbf文件提示损坏,怎么恢复数据
- 求教:在linux下如何安装oracle 10g
使用shutdown immediate需要很谨慎的,要首先停掉数据库监听器,将JOB队列参数设置成0,然后手工关闭所有的ORACLE用户SESSION后,再执行alter system checkpoint 然后shutdown immediate。