How to fix RMAN-06026 & RMAN-06024 errors in RMAN during TSPITR

While Processing Tablespace Point-in-Time Recovery in RMAN, suddenly I got below errors.

RMAN-06026: some targets not found - aborting restore

RMAN-06024: no backup or copy of the control file found to restore

Cause:

This is the problem that rman can not identify the control file for the auxiliary database.

Error Example

RMAN> run

2> {

3> recover tablespace tspitr_tbs

4> until scn 965500

5> auxiliary destination '/u01/aux_dest';

6> }

Starting recover at 30-NOV-15

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=44 device type=DISK

RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point-in-time

List of tablespaces expected to have UNDO segments

Tablespace SYSTEM

Tablespace UNDOTBS1

Creating automatic instance, with SID='shta'

initialization parameters used for automatic instance:

db_name=ORCL

db_unique_name=shta_tspitr_ORCL

compatible=11.2.0.0.0

db_block_size=8192

db_files=200

sga_target=280M

processes=50

db_create_file_dest=/u01/aux_dest

log_archive_dest_1='location=/u01/aux_dest'

#No auxiliary parameter file used

starting up automatic instance ORCL

Oracle instance started

Total System Global Area     292933632 bytes

Fixed Size                     1336092 bytes

Variable Size                100666596 bytes

Database Buffers             184549376 bytes

Redo Buffers                   6381568 bytes

Automatic instance created

Running TRANSPORT_SET_CHECK on recovery set tablespaces

TRANSPORT_SET_CHECK completed successfully

contents of Memory Script:

{

# set requested point in time

set until  scn 965500;

# restore the controlfile

restore clone controlfile;

# mount the controlfile

sql clone 'alter database mount clone database';

# archive current online log

sql 'alter system archive log current';

# avoid unnecessary autobackups for structural changes during TSPITR

sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';

}

executing Memory Script

executing command: SET until clause

Starting restore at 30-NOV-15

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=19 device type=DISK

Removing automatic instance

shutting down automatic instance

Oracle instance shut down

Automatic instance removed

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

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

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

RMAN-03002: failure of recover command at 11/30/2015 17:57:01

RMAN-03015: error occurred in stored script Memory Script

RMAN-06026: some targets not found - aborting restore

RMAN-06024: no backup or copy of the control file found to restore

Solution:

RMAN> list backup of controlfile;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

30      Full    9.36M      DISK        00:00:02     30-NOV-15

        BP Key: 30   Status: AVAILABLE  Compressed: NO  Tag: TAG20151130T171313

        Piece Name: /u02/rman_bkp/control_bkp/c-1423639881-20151130-03.ctl

  Control File Included: Ckp SCN: 960296       Ckp time: 30-NOV-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

34      Full    9.36M      DISK        00:00:02     30-NOV-15

        BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: TAG20151130T231314

        Piece Name: /u02/rman_bkp/control_bkp/c-1423639881-20151130-04.ctl

  Control File Included: Ckp SCN: 965398       Ckp time: 30-NOV-15

RMAN> catalog backuppiece '/u02/rman_bkp/control_bkp/c-1423639881-20151130-04.ctl';

cataloged backup piece

backup piece handle=/u02/rman_bkp/control_bkp/c-1423639881-20151130-04.ctl RECID=37 STAMP=897176040

Result :

RMAN> run

2> {

3> recover tablespace tspitr_tbs

4> until scn 965500

5> auxiliary destination '/u01/aux_dest';

6> }

Starting recover at 30-NOV-15

using channel ORA_DISK_1

RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point-in-time

List of tablespaces expected to have UNDO segments

Tablespace SYSTEM

Tablespace UNDOTBS1

Creating automatic instance, with SID='shta'

initialization parameters used for automatic instance:

db_name=ORCL

db_unique_name=shta_tspitr_ORCL

compatible=11.2.0.0.0

db_block_size=8192

db_files=200

sga_target=280M

processes=50

db_create_file_dest=/u01/aux_dest

log_archive_dest_1='location=/u01/aux_dest'

#No auxiliary parameter file used

starting up automatic instance ORCL

Oracle instance started

Total System Global Area     292933632 bytes

Fixed Size                     1336092 bytes

Variable Size                100666596 bytes

Database Buffers             184549376 bytes

Redo Buffers                   6381568 bytes

Automatic instance created

Running TRANSPORT_SET_CHECK on recovery set tablespaces

TRANSPORT_SET_CHECK completed successfully

contents of Memory Script:

{

# set requested point in time

set until  scn 965500;

# restore the controlfile

restore clone controlfile;

# mount the controlfile

sql clone 'alter database mount clone database';

# archive current online log

sql 'alter system archive log current';

# avoid unnecessary autobackups for structural changes during TSPITR

sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';

}

executing Memory Script

executing command: SET until clause

Starting restore at 30-NOV-15

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=20 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: restoring control file

[--------------Output Trimmed--------------]

[--------------Output Trimmed--------------]

contents of Memory Script:

{

# make read write and offline the imported tablespaces

sql 'alter tablespace  TSPITR_TBS read write';

sql 'alter tablespace  TSPITR_TBS offline';

# enable autobackups after TSPITR is finished

sql 'begin dbms_backup_restore.AutoBackupFlag(TRUE); end;';

}

executing Memory Script

sql statement: alter tablespace  TSPITR_TBS read write

sql statement: alter tablespace  TSPITR_TBS offline

sql statement: begin dbms_backup_restore.AutoBackupFlag(TRUE); end;

Removing automatic instance

Automatic instance removed

auxiliary instance file /u01/aux_dest/ORCL/datafile/o1_mf_temp_c5s478w3_.tmp deleted

auxiliary instance file /u01/aux_dest/ORCL/onlinelog/o1_mf_3_c5s472fx_.log deleted

auxiliary instance file /u01/aux_dest/ORCL/onlinelog/o1_mf_2_c5s47050_.log deleted

auxiliary instance file /u01/aux_dest/ORCL/onlinelog/o1_mf_1_c5s46x2t_.log deleted

auxiliary instance file /u01/aux_dest/ORCL/datafile/o1_mf_sysaux_c5s42ldz_.dbf deleted

auxiliary instance file /u01/aux_dest/ORCL/datafile/o1_mf_undotbs1_c5s42lh6_.dbf deleted

auxiliary instance file /u01/aux_dest/ORCL/datafile/o1_mf_system_c5s42ldj_.dbf deleted

auxiliary instance file /u01/aux_dest/ORCL/controlfile/o1_mf_c5s427mf_.ctl deleted

Finished recover at 30-NOV-15

In my case, it worked. hope this will work in your case. If anyone have better options, please comment. :)

Thanks......