RMAN Question - Hotbackups
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: RMAN Question - Hotbackups

  1. #1
    Join Date
    Sep 2000

    Does RMAN copy the entire datafile during hotbackup or does it copy only the blocks containing data?

    For eg: If the datafile is 1GB but only contains 200MB of data, then does RAMN copy the entire 1GB datafile or only the 200MB (Oracle blocks)?


  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    it copies data block which has ever been used, i.e skips blocks which have never been used

    but if you are using image copy then it copies everything

  3. #3
    Join Date
    Dec 2001
    Keene, NH
    Just to demonstrate a little bit using RMAN hot backups:

    The three files created from my RMAN hot backup process totals 500MB. In OEM, the sum of all the tablespaces sizes 1.6GB

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