Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    70

    Unhappy Unanswered: report unrecoverable

    Hi All,
    My database is in ARCHIVE LOG MODE. I am using RMAN for my backups. My backup strategy is like this:

    Every Sunday Incremental Level 0 backup
    Every Monday Incremental Level 2 backup
    Every Tuesday Incremental Level 2 backup
    Every Wednesday Incremental Level 2 backup
    Every Thursday Incremental Level 1 backup
    Every Friday Incremental Level 1 backup
    Every Saturday Incremental Level 1 backup

    Still when i run report unrecoverable, I could see 3 datafiles listed down. Can anyone help me in identifying the problem? How I can avoid this? I posted this query with Oracle metalink support also, but did not get proper help from them.
    Kindly help with a proper suggestion.

    Thanks in advance.
    Regards,
    qA

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    why not test your backup.
    you can do this two ways:
    1. restore to a different server
    2. you can test your backups against your production server
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jul 2003
    Posts
    70
    Hi,
    Thanks for your post, I did not restore the backup from production to development.
    Can you tell me when does this
    RMAN> report unrecoverable show data?
    What can be done to prevent this??

Posting Permissions

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