RMAN resynchonize question

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Tho Nguyen
    #1

    RMAN resynchonize question

    Hi, folks!

    I am new to RMAN and now trying to configure it. There is one issue
    concerning me.
    Let's say I backup the target database every 6:PM and the database
    generates about 100 archived logs every day.
    So what happens if the database crashs at 5PM? I have the backup at
    6PM of the last day only and no backup of archive logs generated
    between that time.
    Have anynone experienced that any what is your solution?

    Thank a bunch.
    Tags: None
    • Syltrem
      #2
      Re: RMAN resynchonize question

      You should keep 2 copies of your archive logs, on separate disks.
      On separate servers if possible.

      Look at LOG_ARCHIVE_DES T_n syntax

      I keep one copy on a mirrorred disk locally, and one copy on another machine
      which is in a different city.

      But should your database "crash", as you say, most of the times your archive
      logs will still be available. You`ll have lost one datafile, or any part of
      the database but not your archive logs (as long as they are kept on their
      own disk or storage device), so you can recover.
      If you loose your archive logs in both locations (if you save them onto 2
      locations that is) you still have the database. Just hurry to take a good
      backup of it.

      Loosing everything can only happen if the server bursts into flames (or
      something of the like), in which case you need more than your archive logs
      to recover, you need a complete disaster plan.

      Regards,

      Syltrem



      "Tho Nguyen" <tho_pic@yahoo. coma écrit dans le message de
      news:d177c6d9.0 408130930.65c97 d51@posting.goo gle.com...
      Hi, folks!
      >
      I am new to RMAN and now trying to configure it. There is one issue
      concerning me.
      Let's say I backup the target database every 6:PM and the database
      generates about 100 archived logs every day.
      So what happens if the database crashs at 5PM? I have the backup at
      6PM of the last day only and no backup of archive logs generated
      between that time.
      Have anynone experienced that any what is your solution?
      >
      Thank a bunch.

        Comment

        • s.kapitza
          #3
          Re: RMAN resynchonize question

          tho_pic@yahoo.c om (Tho Nguyen) wrote in message news:<d177c6d9. 0408130930.65c9 7d51@posting.go ogle.com>...
          Hi, folks!
          >
          I am new to RMAN and now trying to configure it. There is one issue
          concerning me.
          Let's say I backup the target database every 6:PM and the database
          generates about 100 archived logs every day.
          So what happens if the database crashs at 5PM? I have the backup at
          6PM of the last day only and no backup of archive logs generated
          between that time.
          Have anynone experienced that any what is your solution?
          >
          Thank a bunch.
          backup the archivelogs every hour or as you like.

          regards

          s.kapitza

            Comment

            Previous template Next
            Working...