DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Offline vs. hot backups

  1. #1
    Join Date
    Dec 2001
    Keene, NH
    (9i, Solaris, archivelog mode)

    If you had a 2 hour a day window to do 10 minute RMAN offline backups - would you? Or for some advantage would you choose hot rman backups?

    Starting up the database after the backup I must re-pin objects in the memory. That seems to be the only extra work.

    Thanks in advance for your opinion.

  2. #2
    Join Date
    Dec 2001
    There is no reason to do cold backups these days. Bouncing the instance is a disaster as far as performance is concerned. It takes time to warm up the caches again and all your performance stats are reset. Tom Kyte is always advising people to do online backups with RMAN. This way you don't even need to switch the tablespaces in to backup mode. It's the quickest and least intrusive method of backing up.

    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

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