Backup strategy with RMAN - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Backup strategy with RMAN

  1. #11
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by samdba
    Oh! I think what you are saying is 'Cumulative' or FULL backup will not require to restore all the backups between 'Fri' and failing point. Right?
    No. The backup pieces will have to be online in order for RMAN to read them.


    But, FULL backup everyday will not take much time and disk space.

    All the more reason to perform a full backup every night.


    Right now, we are taking the backup to disk as a temporary solution. Our long term plan is to use Veritas NETBACKUP for taking the backup directly to tape.
    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."

  2. #12
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Good discussion - thanks to all.

    If I can add my 2c: I would NOT clear out the archivelogs as dbasupuser and marist89 suggest. Don't delete archivelogs until you have more than one copy on tape. It's worth setting up a recovery scenario and then imagining what happens when you find that part of a tape is dud (been there!).

    marist89 is right about documenting & testing. You also need to involve the end users (sorry!) to determine the acceptable level of data loss. This will determine the frequency of forcing a log switch and copying the archivelogs to a "safe" location (e.g. the standby machine).
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

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