Can't Recover a Database Saved With the OEM Backup Facility RMAN-06169

APPLIES TO

Oracle Database - Enterprise Edition - Version 8.1.6.0 to 10.1.0.2 [Release 8.1.6 to 10.1]

Information in this document applies to any platform.

SYMPTOMS

RMAN restore fails with RMAN-6169

RMAN-06169: could not read file header for datafile 1 error reason 15

CHANGES

CAUSE

From kcv.c

/* if the controlfile is not a backup then the controlfile checkpoint count

** stored in the file header should be less than or equal the one in the

** controlfile. If it is not, then controlfile is an old restored image

** copy */

If (KCCFHX(&hx->kcvhxft.kccftbch)->kccfhxfh.kccfhtyp!= KCCTYPBC

&& fhp->kcvfhccc > fe.kccfecpc)

{ /* wrong checkpoint count */

Hx->kcvhxerr = KCVHXCPC;

Goto got_header;

}

#define KCVHXCPC 15 /* wrong checkpoint count */

An incorrect version of controlfile is used

The Controlfile was CURRENT but from an older COLD-backup

Than the restored datafiles.

SOLUTION

Restore a more recent controlfile.

DBRECOVER Recovery Options

For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.

When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.