RMAN RESTORE fails with RMAN-00600 [8064] (Doc ID 866883.1)

Last updated on MARCH 26, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
Information in this document applies to any platform.

Symptoms

When RMAN backup is restored to a new database with the same datafile paths as production server, the RESTORE fails with RMAN-00600 [8064]. The error stack looks like the following:

RMAN> restore database preview;
Starting restore at 03-JUN-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=415 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03012: fatal error during compilation of command
RMAN-03028: fatal error code for command restore : 600
RMAN-00600: internal error, arguments [8064] [1] [G:\ORADATA\FRCA\SYSTEM01.DBF]
[G:\ORADATA\FRCP\SYSTEM01.DBF] []

Changes

The path of datafiles in controlfile of production server is different from the path stored in recovery catalog:

SQL> select name from v$datafile ;

NAME
------------------------------------------------
G:\ORADATA\FRCP\SYSTEM01.DBF
G:\ORADATA\FRCP\UNDOTBS01.DBF
G:\ORADATA\FRCP\UNDOTBS02.DBF
G:\ORADATA\FRCP\UNDOTBS03.DBF
G:\ORADATA\FRCP\UNDOTBS04.DBF
G:\ORADATA\FRCP\UNDOTBS05.DBF
G:\ORADATA\FRCP\UNDOTBS06.DBF
G:\ORADATA\FRCP\UNDOTBS07.DBF
G:\ORADATA\FRCP\UNDOTBS08.DBF
G:\ORADATA\FRCP\UNDOTBS09.DBF
G:\ORADATA\FRCP\UNDOTBS10.DBF
G:\ORADATA\FRCP\UNDOTBS11.DBF
.............
.............

RMAN Connected WITHOUT recovery catalog
=================================

RMAN> report schema;
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Da0tafile Name
---- -------- -------------------- ------- ------------------------
1 2048 SYSTEM *** G:\ORADATA\FRCP\SYSTEM01.DBF
2 2048 UNDO *** G:\ORADATA\FRCP\UNDOTBS01.DBF
3 2048 UNDO *** G:\ORADATA\FRCP\UNDOTBS02.DBF
4 2048 UNDO *** G:\ORADATA\FRCP\UNDOTBS03.DBF
5 2048 UNDO *** G:\ORADATA\FRCP\UNDOTBS04.DBF
6 2048 UNDO *** G:\ORADATA\FRCP\UNDOTBS05.DBF
7 2048 UNDO *** G:\ORADATA\FRCP\UNDOTBS06.DBF
8 2048 UNDO *** G:\ORADATA\FRCP\UNDOTBS07.DBF
9 2048 UNDO *** G:\ORADATA\FRCP\UNDOTBS08.DBF
10 2048 UNDO *** G:\ORADATA\FRCP\UNDOTBS09.DBF
................
................

RMAN Connected WITH recovery catalog
=========================

RMAN> report schema;
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 2048 SYSTEM YES G:\ORADATA\FRCA\SYSTEM01.DBF
2 2048 UNDO YES G:\ORADATA\FRCA\UNDOTBS01.DBF
3 2048 UNDO YES G:\ORADATA\FRCA\UNDOTBS02.DBF
4 2048 UNDO YES G:\ORADATA\FRCA\UNDOTBS03.DBF
5 2048 UNDO YES G:\ORADATA\FRCA\UNDOTBS04.DBF
6 2048 UNDO YES G:\ORADATA\FRCA\UNDOTBS05.DBF
7 2048 UNDO YES G:\ORADATA\FRCA\UNDOTBS06.DBF
8 2048 UNDO YES G:\ORADATA\FRCA\UNDOTBS07.DBF
9 2048 UNDO YES G:\ORADATA\FRCA\UNDOTBS08.DBF
10 2048 UNDO YES G:\ORADATA\FRCA\UNDOTBS09.DBF
................
................

RMAN> list incarnation;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 FRCP 674593255 CURRENT 1 15/AUG/08

View RC_DATAFILE will also show a different path then controlfile (V$DATAFILE) of production database.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms