配置STREAM后通过RMAN删除ARCHIVELOG遇到的RMAN-08137的诊断

在主库上配置了Stream后，通过RMAN删除Archivelog时，遇到RMAN-08137错误。

[oracle@rhel5 trace]$ rman target sys/pwd@pridb

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Dec 31 12:41:28 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: pridb (DBID=4049190752)

RMAN> delete archivelog all;

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=140 device type=DISK

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=/.../pridb_1_339_764329253.log thread=1 sequence=339

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=/.../pridb_1_340_764329253.log thread=1 sequence=340

…

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=/.../pridb_1_386_764329253.log thread=1 sequence=386

 

检查Stream配置：

$ sqlplus strmadmin/pwd@pridb

SQL> select CAPTURE_NAME, QUEUE_NAME, START_SCN, STATUS, FIRST_SCN from dba_capture;

CAPTURE_NAME   QUEUE_NAME    START_SCN  STATUS   FIRST_SCN

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

CAPTURE_PROD   DEMODB_QUEUE  7586391    DISABLED 7586391

CAPTURE_DEMODB DEMODB_QUEUE  7592351    ENABLED  7592351

发现配置了二个Capture进程，其中一个状态为DISABLE，一直未启用，是一个错误配置的进程，删除此Capture进程。

SQL> exec dbms_capture_adm.drop_capture('capture_prod');

 

PL/SQL procedure successfully completed

再次执行，Archivelog文件顺利删除。

RMAN> delete archivelog all;

 

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=140 device type=DISK

List of Archived Log Copies for database with db_unique_name ZW

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

 

Key     Thrd Seq     S Low Time

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

450     1    339     A 28-DEC-11

        Name: /.../pridb_1_339_764329253.log

 

452     1    340     A 28-DEC-11

        Name: /.../pridb_1_340_764329253.log

…

544     1    386     A 31-DEC-11

        Name: /.../pridb_1_386_764329253.log

 

Do you really want to delete the above objects (enter YES or NO)? yes

deleted archived log

archived log file name=/.../pridb_1_339_764329253.log RECID=450 STAMP=771071996

deleted archived log

archived log file name=/.../pridb_1_340_764329253.log RECID=452 STAMP=771074309

…

deleted archived log

archived log file name=/.../pridb_1_386_764329253.log RECID=544 STAMP=771330203

Deleted 48 objects

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-714301/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-714301/