Pages

Tuesday, February 23, 2016

Crosscheck archives (CHANGE ARCHIVELOG ALL VALIDATE)

Crosscheck archives (CHANGE ARCHIVELOG ALL VALIDATE)

Summary

Maybe for some reason you have lost some archives or delete them on purpose. The result is the RMAN backup of the archives to constantly fail.

For example you might get error messages from rman backup like this:

channel t1: starting piece 1 at 29-APR-04

released channel: t1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on t1 channel at 04/29/2004 18:01:05

ORA-19505: failed to identify file "/oradmp/archive/PRODDB/PRODDB_1_161663.arc"

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

The workaround is to connect to the RMAN catalog and execute a validation of the archive logs.

The Recovery Manager CHANGE command removes references to a backup piece, (datafile or archivelog) from the controlfile and
recovery catalog when the file no longer exists on disk.

First connect to the RMAN Catalog. Login as oracle owner of the software at the unix and set the ORACLE_HOME.

rman target / catalog rman/*****@RMAN

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

target database Password:

connected to target database: PRODDB (DBID=4131138365)

connected to recovery catalog database

Then crosscheck the archives.

RMAN>CHANGE ARCHIVELOG ALL VALIDATE;

Tip: If you have a RAC system you need to validate archives from both nodes.

No comments:

Post a Comment