need to restore and missing dbf file - help please
440143Jul 23 2006 — edited Jul 23 2006hi there,
im in a desperate situation so any advice would be welcome.
im running Oracle 9.2.4.6 on aix. 5.2
2 weeks ago i added a dbf file to one of the tablespaces , as a symbolic link. Im almost certain that this dbf file has not been used as there was still lots of space in the tablespace.
ive had 3 disk crash on me - which means i have had to do a full recovey , and then use the archive logs to roll forward.
but i have now discovered that this new dbf has not been backuped up because its a symbolic link.
so i dont think im going to be able to open the database, or roll forward.
(im still restoring the files so not had a chance to try it yet)
the disk crash means i have lost disk files and the system files.
am i able to recover from here if i need to. ie rebuild indexes and system
any other ideas?
thanks if you can help