Here is my problem ..One of my disk crashed . It got one datafile trans.dbf . I can't startup my database ..since it is missing . How can I recreate the file . We don't need the objects in that file . We don't have real production objects in that tablespace . This tablespace trans got only one datafile trans.dbf . I know it is my bad management that I don't have backup for this datafile . Can you help to recover my database.
offline/online work if you are in archivelog mode. Otherwise, you receive ORA-01145 error: offline immediate disallowed unless media recovery enabled. I don't believe raghud is in archivelog mode - is that correct?