Restore RMAN Full backup to dev database server with error

Nov 3, 2017 3:15AM

Dear all,

I'm having an issue when restore full prd backup (rman) into dev database server.

1.0 Oracle Error:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 5 needs more recovery to be consistent

ORA-01110: data file 5: '/Space_Staging2/DB/SPDBSTG2/UA_001.dbf'

media recovery complete, elapsed time: 00:27:15

Finished recover at 02-NOV-17

released channel: d1

Recovery Manager complete.

2.0 Full backup finished time

52877 DB FULL COMPLETED 10-23-2017 20:00:41 10-25-2017 23:56:18 51.9269444

3.0 Restore script

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

set until time "to_date('2017-10-25:03:00:00', 'yyyy-mm-dd:hh24:mi:ss')";

RESTORE DATABASE;

SWITCH DATAFILE ALL;

RECOVER DATABASE;

}

Full backup complete on Oct-25 , 23:56 PM but i set recover until Oct-25 , 03:00 AM..

Database Backup and Recovery (MOSC)