Problem with Database restore.

Jan 12, 2017 7:48AM

Dear All,

My LEVEL 0 backup script runs on every 30th day of month(The rest days runs LEVEL 1 backup script)

Today I'm trying to do whole database restore using a control file which was backed along with LEVEL 1 backup today at 03:00:00.

But I'm getting error:

reating datafile file number=1 name=/u01/oracle/amit/system01.dbf

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 01/12/2017 03:19:59

ORA-01180: can not create datafile 1

ORA-01110: data file 1: '/u01/oracle/amit/system01.dbf'

If I try to validate data file 1 I would get empty output:

RMAN> restore validate datafile 1;

datafile 1 will be created automatically during restore operation

Database Backup and Recovery (MOSC)