media recovery - way out
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: media recovery - way out

  1. #1
    Join Date
    Sep 2008
    Posts
    4

    media recovery - way out

    i cannot perform online backup because media recovery is not enable, can anyone help me out pls.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    that doesnt make any sense, you dont enable media recovery, you perform it

    so pos what you are doing and what error you are getting

  3. #3
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    DB might not be in Archive log Mode ....

    Send us the output of:

    SQL>archive log list

    Regards,
    Paresh

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by pareshjavkar
    DB might not be in Archive log Mode ....
    huh?

    ... how did you manage to translate "media recovery..." into ""DB is not in archivelog mode"?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Quote Originally Posted by PAVB
    huh?

    ... how did you manage to translate "media recovery..." into ""DB is not in archivelog mode"?
    He is unable to perform online backup ... huh

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by pareshjavkar
    He is unable to perform online backup ... huh
    ... or perhaps poster has one or more datafiles in need of media recovery... huh?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Quote Originally Posted by PAVB
    ... or perhaps poster has one or more datafiles in need of media recovery... huh?
    Yes, I agree, question seems to be confusing, so just tried to check some basics ... maybe an alert.log might help ...

    Also,

    SQL> select * from v$recover_file output would provide some insight.

    Thanks, PAVB for showing the right path.

    Regards,
    Paresh

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