oracle视图失效,ORACLE 11Gr2 V$ARCHIVED_LOG视图过期信息

此视图的信息来自于基表 x$kccal—- [K]ernel [C]ache [C]ontrolfile management [A]rchived [L]ogfile record

我们在rman下进行archive log删除后，发现在V$ARCHIVE_LOG中发现还是有相关记录，只是状态标记为D(即为已删除),但是list archivelog all时，没有任何记录

这是因为，我们list archived all时也是获取v$archived_log里的信息,但是它只获取status in(‘X’,’A’)两个状态的信息(可以通过10046去佐证此信息)。

下面是分区delete archivelog all前后的区别

SQL> select name,sequence#,status,deleted from v$archived_log;

NAME SEQUENCE# S DEL

——————————————————————————– ———- – —

/oradata/db_recovery_dest/TRSEN/archivelog/2016_01_04/o1_mf_1_2_c8nyq8p8_.arc 2 A NO

/oradata/db_recovery_dest/TRSEN/archivelog/2016_01_04/o1_mf_1_1_c8nd4xj2_.arc 1 A NO

/oradata/db_recovery_dest/TRSEN/archivelog/2016_01_04/o1_mf_1_3_c8nyro5f_.arc 3 A NO

/oradata/db_recovery_dest/TRSEN/archivelog/2016_01_05/o1_mf_1_7_c8o5xprs_.arc 7 A NO

/oradata/db_recovery_dest/TRSEN/archivelog/2016_01_05/o1_mf_1_4_c8o5xkw9_.arc 4 A NO

/oradata/db_recovery_dest/TRSEN/archivelog/2016_01_05/o1_mf_1_6_c8o5xn3j_.arc 6 A NO

/oradata/db_recovery_dest/TRSEN/archivelog/2016_01_05/o1_mf_1_5_c8o5xlms_.arc 5 A NO

/oradata/db_recovery_dest/TRSEN/archivelog/2016_01_05/o1_mf_1_8_c8o5xsrt_.arc 8 A NO

19 rows selected.

SQL> /

NAME SEQUENCE# S DEL

——————————————————————————– ———- – —

2 D YES

1 D YES

3 D YES

7 D YES

4 D YES

6 D YES

5 D YES

8 D YES

19 rows selected.

现在我们利用9i里遗留的方法，在9ionline上说是为了解决在8i及8i之前因ctl文件两条记录对应的同一个物理文件信息；

在11g中online help上没有找到相关存储过程说明

execute sys.dbms_backup_restore.resetCfileSection(11);

注意：

1、在处理过程中会清理ctl文件所有状态的archivelog信息.

2、一般不建议处理

清理完后需要手动注册在归档目录的日志信息方法如下:

RMAN> catalog start with ‘/oradata/db_recovery_dest/TRSEN/archivelog’;

此存储调用，是个很简单的存储过程，传递类型，其类型有哪些见如下列表

PROCEDURE resetCfileSection(record_type IN binary_integer );

–This procedure attempts to reset the circular controlfile section.

–Input parameters:

–record_type

–The circular record type whose controlfile section is to be reset.

类型列表如下：

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

23=>DATABASE INCARNATION

24=>FLASHBACK LOG

25=>RECOVERY DESTINATION

26=>INSTANCE SPACE RESERVATION

27=>REMOVABLE RECOVERY FILES

28=>RMAN STATUS

29=>THREAD INSTANCE NAME MAPPING

30=>MTTR

31=>DATAFILE HISTORY

32=>STANDBY DATABASE MATRIX

33=>GUARANTEED RESTORE POINT

34=>RESTORE POINT

35=>DATABASE BLOCK CORRUPTION

36=>ACM OPERATION

37=>FOREIGN ARCHIVED LOG