accidentally deleted empty datafile at OS level, and have no backup of it!!
1006768May 2 2013 — edited May 2 2013Oracle 11G
Hello
After creating a new datafile, it was accidentally deleted at OS level (AIX).
Because it was new there are no backups of it.
Now tablespace thinks there are 3 datafiles in it, but one of them is missing.
Is it possible to recreate an empty data file on-the-fly?
It has let me set the datafile to offline, but wouldnt let me do anything else.
Now my backups are failing as it recognises :
"the status of database file is RECOVER"
Any advice would be greatly appreciated