DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: recover using logical backup

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    Angry

    Hi
    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.

    cheese
    anandkl
    anandkl

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi,

    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

    Angel

  3. #3
    Join Date
    Nov 2001
    Posts
    335

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width