Re: RMAN MISSING BKP FILES

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

Best Wishes

Howard A. Latham

On Mon, 5 Nov 2018 at 14:29, 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