Surviving a Database Disaster with RMAN Backups
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Surviving a Database Disaster with RMAN Backups

  1. #1
    Join Date
    Apr 2002
    Location
    France
    Posts
    118

    Surviving a Database Disaster with RMAN Backups

    Hi,

    I read the new doc http://www.dbasupport.com./oracle/ora9i/rman.shtml

    I got really surprised when the author says RMAN could not find his last archive logs : "[...] RMAN catalog did not understand archive logs that were created after we had run the RMAN backup. We had to do manual cataloging of all the archive logs [...]"

    I well thought RMAN recorded the archive log as soon as the redolog got archived.

    What do you people think ? have you faced that kind of problem before ?
    Thanks to share your experience.
    If there is no solution, it is because there is no problem - Shadok -

  2. #2
    Join Date
    Jan 2004
    Location
    Paris, France
    Posts
    52
    Hi

    You may find answers to your question on Metalink

    Doc ID: Note:155656.1
    Subject: Redo Log File Management and Issues when using RMAN to do Automatic Recovery
    Type: BULLETIN
    Status: PUBLISHED

    Latyr

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    How would rman know about archived redo if it hasn't backed them up?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Apr 2002
    Location
    France
    Posts
    118
    Thanks,to you both, I'll read the doc completely when I'll be less busy

    I know why I got confused, this is from the user's guide
    "
    Oracle records an archived log in
    the control file whenever one of the following occurs:
    n The archiver process archives a redo log
    n RMAN restores an archived log
    n The RMAN COPY command copies a log
    n The RMAN CATALOG command catalogs a user-managed backup of an
    archived log
    " ... nothing to do with the catalog!

    Also, that's good to see about the 9i enhancements on the metalink doc.

    One last question : how often do you resync ? Twice a day ?
    If there is no solution, it is because there is no problem - Shadok -

  5. #5
    Join Date
    Oct 2002
    Posts
    807
    RMAN automatically issues a resync when you issue a "backup" or a "delete". You only need to resync manually if you aren't connected to the catalog during backups. The RMAN user guide talks at length about it.

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