so I tried to revert them and got the same error.and at this level the rman is not performing the restoration operation.it is after backup based cloning.
NID-00111: Oracle error reported from target database while executing begin dbms_backup_restore.nidprocessdf(:fno, :istemp, :skipped, :idchged, :nmchged); end; ORA-01116: error in opening database file /d01/oramall/db/apps_st/data/temp01.dbf ORA-27037: unable to obtain file status Linux-x86_64 Error: 13: Permission denied Additional information: 3 ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 6694 ORA-06512: at line 1
check that particular file permission
this file is not the part of the instance.
SQL> Select distinct(FHDBI) ,count(*) from x$kcvfh group by fhdbi; Select distinct(FHDBI) ,count(*) from x$kcvfh group by fhdbi * ERROR at line 1: ORA-01507: database not mounted SQL> alter database mount; alter database mount * ERROR at line 1: ORA-00205: error in identifying control file, check alert log for more info