All,
I am trying to develop a non-standard backup and recovery operation for my development group.
I have hit a wall where I have created orphan backups and now wish to restore/recover with them.
Though, the Oracle documentation says that you can, I cannot find a good procedure around.
This is "non-standard" because I am trying to develop a method of backing up and restoring
"non archivelog" databases. I know this is odd. But, I have a need for functionality like this.
What I have done up to now is:
a. reset database incarnation
b. restore control file of tagged backup that I want.
When I attempt a restore, I get the following:
RMAN> restore database from tag FIFTH ;
Starting restore at 24-DEC-15
Starting implicit crosscheck backup at 24-DEC-15
allocated channel: ORA_DISK_1
Crosschecked 15 objects
Finished implicit crosscheck backup at 24-DEC-15
Starting implicit crosscheck copy at 24-DEC-15
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 24-DEC-15
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: +RECO/OTMDX31/AUTOBACKUP/2015_12_21/s_899021811.445.899021855
File Name: +RECO/OTMDX31/AUTOBACKUP/2015_12_21/s_899038126.3914.899038175
File Name: +RECO/OTMDX31/BACKUPSET/2015_12_21/ncnnf0_fifth_cf_0.4341.899021855
File Name: +RECO/OTMDX31/BACKUPSET/2015_12_21/nnndn0_threeb_0.3257.899038165
File Name: +RECO/OTMDX31/BACKUPSET/2015_12_21/ncnnf0_threeb_cf_0.3378.899038173
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/24/2015 04:51:11
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 8 found to 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
From the list of "cataloged" files, it is clear that RMAN does not recognize the file that contains backups
of the datafiles indicated above. However, the file is recognized when I do a "list backup" :
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15 Incr 0 1.49G DISK 00:00:05 21-DEC-15
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: FIFTH
Piece Name: +RECO/OTMDX31/BACKUPSET/2015_12_21/nnndn0_fifth_0.4379.899021845
List of Datafiles in backup set 15
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 1762324 21-DEC-15 +DATA/OTMDX31/DATAFILE/system.2016.899006863
2 0 Incr 1762324 21-DEC-15 +DATA/OTMDX31/DATAFILE/undotbs2.2585.899007097
3 0 Incr 1762324 21-DEC-15 +DATA/OTMDX31/DATAFILE/sysaux.2018.899006821
4 0 Incr 1762324 21-DEC-15 +DATA/OTMDX31/DATAFILE/undotbs1.2013.899006909
5 0 Incr 1762324 21-DEC-15 +DATA/otmdx31/datafile/second.dbf
6 0 Incr 1762324 21-DEC-15 +DATA/OTMDX31/DATAFILE/users.2014.899006909
7 0 Incr 1762324 21-DEC-15 +DATA/otmdx31/datafile/third.dbf
8 0 Incr 1762324 21-DEC-15 +DATA/otmdx31/datafile/fourth.dbf
I've tried to explicitly catalog the file:
catalog backuppiece '+RECO/OTMDX31/BACKUPSET/2015_12_21/nnndn0_fifth_0.4379.899021845' ;
This command succeeded but had no effect on my outcome.
Can anyone share insight?
Regards,
John