How do you knwo if an archived log has been damaged?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How do you knwo if an archived log has been damaged?

  1. #1
    Join Date
    Feb 2002
    Posts
    59


    Oracle suggest:

    "WARNING: If you know that an archived redo log group has been damaged, immediately back up all datafiles so that you will have a whole database backup that does not require the damaged archived redo log. "

    Question:

    How do you knwo if an archived log has been damaged?


  2. #2
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Use Verify Utility...to verify...curruptions if any..
    Other wise try setting db_block_checksum= true in init.ora
    Thanks.
    Thanigaivasan..

  3. #3
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by thanigai
    Use Verify Utility...to verify...curruptions if any..
    Other wise try setting db_block_checksum= true in init.ora
    Thanks.
    Thanigaivasan..
    You cannot use the verufy utility dbverify to verify corruptions in archive log files.

    Its only for the datafiles
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

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