RMAN-6026 RMAN-6023 During RESTORE Operation

Posted by PDSERVICE on Mar 08, 2020 In

Problem Description

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

You are attempting to restore a database using Oracle Recovery

Manager (RMAN) using a 'set until time' parameter to do a point-in-time

recovery:

run {

set until time = '09-JUN-2000:10:30:00';

allocate channel x type disk;

restore database;

recover database;

}

However, this command fails with the following error stack:

RMAN-03002: failure during compilation of command

RMAN-03013: command type: restore

RMAN-03002: failure during compilation of command

RMAN-03013: command type: IRESTORE

RMAN-06026: some targets not found - aborting restore

RMAN-06023: no backup or copy of datafile 7 found to restore

RMAN-06023: no backup or copy of datafile 6 found to restore

RMAN-06023: no backup or copy of datafile 5 found to restore

RMAN-06023: no backup or copy of datafile 4 found to restore

RMAN-06023: no backup or copy of datafile 3 found to restore

RMAN-06023: no backup or copy of datafile 2 found to restore

RMAN-06023: no backup or copy of datafile 1 found to restore

...

A 'list backupset of database' command shows there to be multiple backups

of these files available.

Solution Description

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

You have issued a 'resetlogs' prior to the last backup but before the 'Until

Time' clause in the RMAN script.

For instance,

- the last BACKUP taken of the database was June 8, 2000.

- you opened the database with RESETLOGS On June 9, at 9:08 AM,

- Then, do to complications, you decide to restore the database to a point in time on June 9, 10:30 AM.

Because you cannot roll forward through the resetlogs, RMAN cannot find any legitimate

backups to restore from within this incarnation.

o The solution is to reset database incarnation to previous incarnation and

set the 'until time' clause to a time before the resetlogs.

Explanation

-----------

You need to check the incarnation of the database:

rman>list incarnation of database;

RMAN-03022: compiling command: list

List of Database Incarnations

DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time

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

1 2 <backup name> 4094805351 NO 159907 28-apr-2000:10:24:43

1 461 <backup name> 4094805351 NO 220532 09-jun-2000:08:22:08

1 521 <backup name> 4094805351 YES 220693 09-jun-2000:09:08:20

If the current incarnation reset time falls between the last backup and

the time specified for 'Set Time,' then the recovery catalog acknowledges

that there are no backups that match the time criteria specified, and errors

out with RMAN-6023.

Search Words

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

BACKUP, COPY, RECOVER, TARGETS

REFERENCES

You are here

RMAN-6026 RMAN-6023 During RESTORE Operation

RMAN-6026 RMAN-6023 During RESTORE Operation