My database crashes, i have only logical backup no physical backup how can i restore my database and what are the requirements to be met.
please reply urgently.
If you only have a full export, then you must recreate the database and then import full. Take care you're dropped the files from disk. This will recreate all your tablespaces, users ...
Hope that helps
Restore from logical backup
You can create brand new database and create just system,rollback segment and temporary tablespace. Then, provided that you restore on a same server or you have same mount points on a different server you can run a full import. It will recreate all tablespaces, datafiles ,users, etc.
If you do not have same mount points, you will have to create all tablespaces first and then do a full import.
That will work if you database has a reasonable size.
Watch for invalid objects after import completed!
One, who thinks that the other one who thinks that know and does not know, does not know either!
Click Here to Expand Forum to Full Width