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
Printable View
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
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
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