Re: RMAN MISSING BKP FILES

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>
jrodriguez2_at_pythian.com
*www.pythian.com* <https://www.pythian.com/> [image: Pythian] <https://www.pythian.com/email-footer-click>

On Mon, 5 Nov 2018 at 15:30, Howard Latham <howard.latham_at_gmail.com> wrote:

> 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_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 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
>
>
>

-- 


--






--
http://www.freelists.org/webpage/oracle-l