Oracle DBF accidently deleted.
Hi,
I had accidental deleted some of the DBF files . I thought I did a backup. But when I check my backup folder is empty. Apparently my backupscript is not working for a very long time. And there another script that delete backup files older then 1 week. Since I did not check this folder for a long time I didnt know it happen.
The file I deleted as below,
-sysaux01.dbf
-sdata01.dbf
-sindex01.dbf
-system02.dbf
Is there anyway to save it? Currently I still do not dare to shutdown the DB and the server.
I tried using rman > target connect /
ORACLE error from target database:
ORA-00604: error occurred at recursive SQL level 1
ORA-01116: error in opening database file 1
ORA-01110: data file 1: '/u02/oradata/unisit11/dbf/system01.dbf'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Additional information: 3
error executing package DBMS_RCVMAN in TARGET database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 06/01/2012 15:33:29
RMAN-06429: TARGET database is not compatible with this version of RMAN
PS. Pro's out there do feel free to scold me . Is my mistake. but please shed some light? Steps , method / link , etc