近日在测试环境对备份脚本测试的时候，发现v$archived_log视图中name显示为空，对日常维护工作带来一定影响，处理过程记录一下http://www.cndba.cn/asker/article/1751

SQL>  select recid,first_time,name from v$archived_log;

     RECID FIRST_TIME   NAME
---------- ------------ ------------------------------
        39 03-DEC-16
        40 03-DEC-16
        41 03-DEC-16
        42 04-DEC-16
        43 04-DEC-16
        44 04-DEC-16
        45 05-DEC-16
        46 05-DEC-16
        47 05-DEC-16
        48 05-DEC-16
        49 05-DEC-16

     RECID FIRST_TIME   NAME
---------- ------------ ------------------------------
        50 05-DEC-16
        51 05-DEC-16
        52 05-DEC-16
        53 05-DEC-16

原因：使用rman删除归档日志的时候没有清楚掉控制文件中相关信息

http://www.cndba.cn/asker/article/1751

处理过程：

--查看控制文件中各项编号
http://www.cndba.cn/asker/article/1751

SQL> select rownum-1 session_id, type from v$controlfile_record_section;

SESSION_ID TYPE
---------- ------------------------------
         0 DATABASE
         1 CKPT PROGRESS
         2 REDO THREAD
         3 REDO LOG
         4 DATAFILE
         5 FILENAME
         6 TABLESPACE
         7 TEMPORARY FILENAME
         8 RMAN CONFIGURATION
         9 LOG HISTORY
        10 OFFLINE RANGE
        11 ARCHIVED LOG
        12 BACKUP SET
        13 BACKUP PIECE
        14 BACKUP DATAFILE
        15 BACKUP REDOLOG
        16 DATAFILE COPY
        17 BACKUP CORRUPTION
        18 COPY CORRUPTION
        19 DELETED OBJECT
        20 PROXY COPY
        21 BACKUP SPFILE
        22 DATABASE INCARNATION
        23 FLASHBACK LOG
        24 RECOVERY DESTINATION
        25 INSTANCE SPACE RESERVATION
        26 REMOVABLE RECOVERY FILES
        27 RMAN STATUS
        28 THREAD INSTANCE NAME MAPPING
        29 MTTR
        30 DATAFILE HISTORY
        31 STANDBY DATABASE MATRIX
        32 GUARANTEED RESTORE POINT
        33 RESTORE POINT
        34 DATABASE BLOCK CORRUPTION
        35 ACM OPERATION
        36 FOREIGN ARCHIVED LOG


37 rows selected.http://www.cndba.cn/asker/article/1751

 
  

   http://www.cndba.cn/asker/article/1751
  

--清空控制文件中关于v$archived_log的信息

SQL> execute sys.dbms_backup_restore.resetCfileSection(11);


PL/SQL procedure successfully completed.

 http://www.cndba.cn/asker/article/1751

--查询v$archived_log确认

SQL> select recid,first_time,name from v$archived_log;


no rows selected.
  

   http://www.cndba.cn/asker/article/1751
  


 

--将未过期的归档注册回去控制文件 

RMAN> catalog start with '/appl/oracle/archive_log/';

using target database control file instead of recovery catalog
searching for all files that match the pattern /appl/oracle/archive_log/

List of Files Unknown to the Database
=====================================
File Name: /appl/oracle/archive_log/arch1_976_918848528.dbf

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /appl/oracle/archive_log/arch1_976_918848528.dbf

--查看v$archived_log 确认

SQL> col name for a50;
SQL> select recid,first_time,name from v$archived_log;

     RECID FIRST_TIME   NAME
---------- ------------ --------------------------------------------------
         1 14-FEB-17    /appl/oracle/archive_log/arch1_976_918848528.dbf

http://www.cndba.cn/asker/article/1751

版权声明：本文为博主原创文章，未经博主允许不得转载。

v$archived_log rman