Analysis and Solution of RMAN-06026 errors

Background:
An incomplete SCN-based recovery was previously implemented. During the restoration attempt, the _ allow_resetlogs_uption parameter was used. After resetlogs, the current control file used by Oracle does not allow recovery from this historical backup set, leading to the RMAN-06026 error as follows:

Error:
RMAN> restore database;

Starting restore at 26-JUL-12
Using target database control file instead of recovery catalog
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid = 47 devtype = DISK

RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03002: failure of restore command at 07/26/2012 12:41:17
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

Error analysis:
First of all, our database must have been fully standby. However, we can see that there is no live backup copy of data files from the information returned from the above recovery. We can consider using this method at this time.
Dbms_backup_resetore is used to specify the path for manual database recovery. The detailed steps are as follows:

Solution:
Run the dbms_backup_restore package to restore:

DECLARE
Devtype varchar2 (256 );
Done boolean;
BEGIN
Devtype: = sys. dbms_backup_restore.deviceAllocate (type => '', ident => 'fun ');
Sys. dbms_backup_restore.restoreSetDatafile;
Sys. dbms_backup_restore.restoreDatafileTo (dfnumber => 01, toname => '/DBBak2/oradata/WWL/system01.dbf ');
Sys. dbms_backup_restore.restoreDatafileTo (dfnumber => 02, toname => '/DBBak2/oradata/WWL/undotbs01.dbf ');
Sys. dbms_backup_restore.restoreDatafileTo (dfnumber => 03, toname => '/DBBak2/oradata/WWL/sysaux01.dbf ');
Sys. dbms_backup_restore.restoreDatafileTo (dfnumber => 04, toname => '/DBBak2/oradata/WWL/users01.dbf ');
Sys. dbms_backup_restore.restoreDatafileTo (dfnumber => 05, toname => '/DBBak2/oradata/WWL/wwl001.dbf ');
Sys. dbms_backup_restore.restoreDatafileTo (dfnumber => 06, toname => '/DBBak2/oradata/WWL/wwl002.dbf ');
Sys. dbms_backup_restore.restoreDatafileTo (dfnumber => 07, toname => '/DBBak2/oradata/WWL/wwl003.dbf ');
Sys. dbms_backup_restore.restoreBackupPiece (done => done, handle => '/DBSoft/product/10.2.0/db_1/dbs/0pnh23kk_1_1', params => null );
Sys. dbms_backup_restore.deviceDeallocate;
END;
/

1 2 Next Page