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

Thread: RMAN Question - Hotbackups

  1. #1
    Join Date
    Sep 2000
    Posts
    155

    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)?


    TIA

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
    Location
    Keene, NH
    Posts
    510
    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