Home > Database > Mysql Tutorial > Oracle归档空间不足,delete archivelog all;命令失效时解决方法

Oracle归档空间不足,delete archivelog all;命令失效时解决方法

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 17:03:44
Original
1147 people have browsed it

描述:如果归档日志写满磁盘空间,如果使用操作系统的命令删除归档日志,Oracle并不能识别出有空闲的空间。在rman中使用delete ar

描述:如果归档日志写满磁盘空间,如果使用操作系统的命令删除归档日志,Oracle并不能识别出有空闲的空间。在rman中使用delete archivelog all命令还不能解决时,可以尝试下面的命令。

手工删除归档日志,Rman备份检测到日志缺失,从而无法进行下一步操作:

手工执行crosscheck命令:

RMAN>crosscheck archivelog all;

删除过期日志:

RMAN>delete expired archivelog all;

提示是否删除,选择“YES”

如果数据库处于mount状态

SQL>alter database open;

linux

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template