Oracle出错:由于输出设备已满或不可用, 归档程序无法归档重做日志。归档日志错误！

最新推荐文章于 2021-08-09 02:28:24 发布

Endwin_wan

最新推荐文章于 2021-08-09 02:28:24 发布

阅读量2.4k

点赞数

分类专栏： Oracle 备份与恢复文章标签： oracle delete file flash integer system

本文链接：https://blog.csdn.net/Endwin_wan/article/details/7452175

版权

Oracle 备份与恢复专栏收录该内容

2 篇文章 0 订阅

订阅专栏

1、查看db_recovery

SQL> show parameter db_recovery

NAME                                          TYPE               VALUE
------------------------------------      -----------         ------------------------------
db_recovery_file_dest             string             G:\oracle\product\10.2.0\flash _recovery_area
db_recovery_file_dest_size     big integer    2G

2、查看trc文件

ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
*** 2012-04-11 11:07:28.406
************************************************************************
You have following choices to free up space from flash 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.

发现db_recovery_file_dest_size的空间已全部用完，打开G:\oracle\product\10.2.0\flash _recovery_area发现确实超过2G

第一种方法：扩大db_recovery_file_dest_size的容量

sql>alter system set db_recovery_file_dest_size = 4g scope=both;(mount状态)

此方法治标不治本，只能暂时解决。
第二种方法：使用RMAN删除日志

C:\Documents and Settings\Administrator>rman target /
RMAN>backup archivelog all;
RMAN>backup archivelog all delete all input;

RMAN>crosscheck archivelog all;
RMAN>delete expired archivelog all;