RMAN MISSING BKP FILES
Date: Mon, 5 Nov 2018 14:29:14 +0000
Message-ID: <CAPCNhx2Faju=cbhyaD0abX1aY-NaMR6sH=9yJ2ySg=hF8oCbjw_at_mail.gmail.com>
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.bkpList 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_at_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_at_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_at_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 restoreRMAN-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:55RMAN-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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 05 2018 - 15:29:14 CET