RMAN MISSING BKP FILES

Discussion:

Howard Latham

2018-11-05 14:29:14 UTC

Oracle 11.2.0.4
REDHAT 6

I'm sure this is obvious I HAVE done a google.
When I try to restore a database on a new machine the backups for
datafiles 1-5 are cataloged and on disk. But when I do a "restore database"
rman says the file - bkp is NOT there. I'm a bit puzzled. any Ideas ?

RMAN> list backup of datafile 1;

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
142855 Full 8.20G DISK 00:00:00 19-SEP-18
BP Key: 182060 Status: AVAILABLE Compressed: YES Tag:
TAG20180918T213510
Piece Name: /u01/restore1/BARBPRD1_20180919_144726_1.bkp
List of Datafiles in backup set 142855
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 65481786566 19-SEP-18 /u02/oradata/barb/system01.dbf

RMAN> host;

No protocol specified
vncconfig: unable to open display ":1.0"
[1]+ Exit 1 vncconfig
[***@LXSERV9][barbprd1:dbhome_1][/u01/restore1]
[14:28:25]$ ls /u01/restore1/BARBPRD1_20180919_144726_1.bkp
/u01/restore1/BARBPRD1_20180919_144726_1.bkp
[***@LXSERV9][barbprd1:dbhome_1][/u01/restore1]
[14:28:34]$ ls /u01/restore1/BARBPRD1_20180919_144726_1.bkp -lrth
-rw-rw-rw- 1 oracle oracle 8.2G Sep 19 20:38
/u01/restore1/BARBPRD1_20180919_144726_1.bkp
[***@LXSERV9][barbprd1:dbhome_1][/u01/restore1]
[14:28:38]$ exit
exit
host command complete

RMAN> restore database;

Starting restore at 05-NOV-18
configuration for DISK channel 2 is ignored
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=576 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/05/2018 14:28:45
RMAN-06026: some targets not found - aborting 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

RMAN> restore datafile 1;

Starting restore at 05-NOV-18
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/05/2018 14:28:55
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>

Best Wishes

Howard A. Latham

Jose Rodriguez

2018-11-05 15:02:33 UTC

Permalink

Something similar happened to me once.
Make sure that the right DBID of the backup files is set in the RMAN
session so it can "find" the proper backups.
If this is checked already, I'd guess it would be something related to DBID
and/or incarnation.

Just my $0.02.

[image: Pythian] <http://www.pythian.com/>
*Jose Rodriguez* | Oracle Database Consultant | [image: LinkedIn]
<https://www.linkedin.com/company/pythian>
*t* +1 613 565 8696 <+1+613+565+8696> *ext.* 1393
*m* +34 607 55 49 91 <+34+607+55+49+91>
***@pythian.com
*www.pythian.com* <https://www.pythian.com/>
[image: Pythian] <https://www.pythian.com/email-footer-click>

Post by Howard Latham
Oracle 11.2.0.4
REDHAT 6
I'm sure this is obvious I HAVE done a google.
When I try to restore a database on a new machine the backups for
datafiles 1-5 are cataloged and on disk. But when I do a "restore database"
rman says the file - bkp is NOT there. I'm a bit puzzled. any Ideas ?
RMAN> list backup of datafile 1;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
142855 Full 8.20G DISK 00:00:00 19-SEP-18
TAG20180918T213510
Piece Name: /u01/restore1/BARBPRD1_20180919_144726_1.bkp
List of Datafiles in backup set 142855
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 65481786566 19-SEP-18 /u02/oradata/barb/system01.dbf
RMAN> host;
No protocol specified
vncconfig: unable to open display ":1.0"
[1]+ Exit 1 vncconfig
[14:28:25]$ ls /u01/restore1/BARBPRD1_20180919_144726_1.bkp
/u01/restore1/BARBPRD1_20180919_144726_1.bkp
[14:28:34]$ ls /u01/restore1/BARBPRD1_20180919_144726_1.bkp -lrth
-rw-rw-rw- 1 oracle oracle 8.2G Sep 19 20:38
/u01/restore1/BARBPRD1_20180919_144726_1.bkp
[14:28:38]$ exit
exit
host command complete
RMAN> restore database;
Starting restore at 05-NOV-18
configuration for DISK channel 2 is ignored
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=576 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/05/2018 14:28:45
RMAN-06026: some targets not found - aborting 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
RMAN> restore datafile 1;
Starting restore at 05-NOV-18
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/05/2018 14:28:55
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 1 found to restore
RMAN>
Best Wishes
Howard A. Latham

--
--

Howard Latham

2018-11-05 15:56:16 UTC

Permalink

Thanks 'missing' backup files were due to files in flashback area with
different incarnation.

Best Wishes

Howard A. Latham