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
[oracle@LXSERV9][barbprd1:dbhome_1][/u01/restore1]
[14:28:25]$ ls /u01/restore1/BARBPRD1_20180919_144726_1.bkp
/u01/restore1/BARBPRD1_20180919_144726_1.bkp
[oracle@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
[oracle@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
