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;