RMAN-06023: no backup or copy of datafile 1 found to restore

Aug 21, 2018 10:09AM

windows server 2012 2 std

oracle 12.1.02

i am trying to restore a database to a point in time and getting the error: RMAN-06023: no backup or copy of datafile 1 found to restore

run

{

set until time = "to_date('2018/08/03 01:10:27', 'YYYY/MM/DD hh24:mi:ss')";

restore database;

recover database;

}

however, when i do a list datafile: list backup of datafile 1 completed before 'sysdate-19';

i do see the datafile available:

BS Key Type LV Size

Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1916	Incr 1 10.93M	DISK	00:00:42	01-AUG-18
	BP Key: 2164 Status: AVAILABLE Compressed: YES Tag: BACKUP_INC-SMO_HUM_080118041505

Database Backup and Recovery (MOSC)