database recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: database recovery

  1. #1
    Join Date
    Mar 2001
    Posts
    29
    is it possible to force the datafile to online even if i can't recover the datafile.
    say media recovery is not possible coz of loss of archive logs.
    dino

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    If you have lost the logs, I think you shall recover all your datafiles from backup to have a consistent database.

    Good look

    Regards

    Angel

  3. #3
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    There is a way to get the file online, but as Arroyob stated your database will be inconsistent/unreliable. It is a technique that should only be used as a last resort or to extract data that would otherwize be lost.

    If it is only one datafile, then it is possible that you can recover it with the logs available (if they are the most recent.)

    It would probably be safer to just vary the file offline. The database will come up.

    The best bet is tobite the bullet, restore your last cold backup and recover with the archive logs you have.

    THere are other possibilities depending on your Oracle release.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  4. #4
    Join Date
    Mar 2001
    Posts
    29
    could u state more specific on how to make a datafile online from recover state without sync. the change#
    just like to know the way... in case a last resort is needed
    dino

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