ORA-00257归档日志写满的解决方法

ASM删除archivelog

1. 查询当前归档路径

   $export oracle_sid=his1

   $sqlplus / nolog

   SQL>archive log list;

2. asmcmd命令行删除指定archivelog

   $export oracle_sid=+ASM1

   $asmcmd

   asmcmd>cd +FBR/HIS1/ARCHIVELOG

   asmcmd>rm -fr 2016_01*

3. 从RMAN中效验并删除过去文档

   $export oracle_sid=his1

   $rman target /

   RMAN>crosscheck archivelog all;

   RMAN>delete expired archivelog all;

   RMAN>crosscheck archivelog all;

RMAN备份报RMAN-06059解决办法

RMAN>change archivelog all crosscheck;