[20181225]如何清除注册的在线日志.txt-优快云博客

本文详细介绍了如何使用Oracle RMAN工具注册在线日志作为归档日志，以及如何取消这一注册。通过具体步骤演示，包括环境设置、RMAN注册过程、取消注册的方法，并重新注册归档文件。

[20181225]如何清除注册的在线日志.txt

--//链接http://www.itpub.net/thread-2107381-1-1.html的讨论,lz可能使用rman的catalog注册了在线日志当作归档日志.

--//我大概演示这个过程,也许作者不是这样操作的.

1.环境:

SYS@book> @ ver1

PORT_STRING VERSION BANNER

------------------------------ -------------- --------------------------------------------------------------------------------

x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

SYS@book> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /u01/app/oracle/archivelog/book/

Oldest online log sequence 703

Next log sequence to archive 705

Current log sequence 705

SELECT RECID

,NAME

,DEST_ID

,THREAD#

,SEQUENCE#

,CREATOR

,REGISTRAR

FROM v$archived_log a

WHERE a.name IS NOT NULL AND sequence# >= 703;

RECID NAME DEST_ID THREAD# SEQUENCE# CREATOR REGISTR

---------- ------------------------------------------------------------ ---------- ---------- ---------- ------- -------

1249 /u01/app/oracle/archivelog/book/1_703_896605872.dbf 1 1 703 ARCH ARCH

1250 /u01/app/oracle/archivelog/book/1_704_896605872.dbf 1 1 704 ARCH ARCH

--//当前并没有在线日志文件在视图v$archived_log中.

2.使用rman注册:

RMAN> catalog archivelog '/mnt/ramdisk/book/redo01.log' ;

cataloged archived log

archived log file name=/mnt/ramdisk/book/redo01.log RECID=1251 STAMP=995797230

SELECT RECID

,NAME

,DEST_ID

,THREAD#

,SEQUENCE#

,CREATOR

,REGISTRAR

FROM v$archived_log a

WHERE a.name IS NOT NULL AND sequence# >= 703;

RECID NAME DEST_ID THREAD# SEQUENCE# CREATOR REGISTR

---------- ------------------------------------------------------------ ---------- ---------- ---------- ------- -------

1249 /u01/app/oracle/archivelog/book/1_703_896605872.dbf 1 1 703 ARCH ARCH

1250 /u01/app/oracle/archivelog/book/1_704_896605872.dbf 1 1 704 ARCH ARCH

1251 /mnt/ramdisk/book/redo01.log 1 1 704 RMAN RMAN

--//你可以发现在线日志文件注册为归档,但是提示CREATOR=rman.如何取消很简单执行:

--//参考链接:http://blog.itpub.net/267265/viewspace-748366/

3.如何取消.

SYS@book> execute dbms_backup_restore.resetcfilesection(11);

PL/SQL procedure successfully completed.

SELECT RECID

,NAME

,DEST_ID

,THREAD#

,SEQUENCE#

,CREATOR

,REGISTRAR

FROM v$archived_log a

WHERE a.name IS NOT NULL AND sequence# >= 703;

no rows selected

--//再重新注册回去归档文件.

RMAN> catalog start with '/u01/app/oracle/archivelog/book/';

searching for all files that match the pattern /u01/app/oracle/archivelog/book/

List of Files Unknown to the Database

=====================================

File Name: /u01/app/oracle/archivelog/book/1_696_896605872.dbf

File Name: /u01/app/oracle/archivelog/book/1_698_896605872.dbf

File Name: /u01/app/oracle/archivelog/book/1_704_896605872.dbf

File Name: /u01/app/oracle/archivelog/book/1_703_896605872.dbf

File Name: /u01/app/oracle/archivelog/book/1_695_896605872.dbf

File Name: /u01/app/oracle/archivelog/book/1_701_896605872.dbf

File Name: /u01/app/oracle/archivelog/book/1_697_896605872.dbf

File Name: /u01/app/oracle/archivelog/book/1_700_896605872.dbf

File Name: /u01/app/oracle/archivelog/book/1_699_896605872.dbf

File Name: /u01/app/oracle/archivelog/book/1_702_896605872.dbf

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

cataloging files...

cataloging done

List of Cataloged Files

=======================