Guys,
Running 8.1.7 on Solaris 2.8. Assuming I've created a new database with a new tablespace called data which is 100M. None of the blocks in this tablespace has been ever used by Oracle. The question is :-
1. If backing up the datafile using rman online and level 0 (full) , what will be the size of the backup ? I ask this coz RMAN will only copy the used blocks.

2. If I do a restore of this datafile, what will be the size ? Again if oracle copies only the used blocks, then my backup will contain only the used blocks and in my case only the header will be copied.
Does it get the info from the controlfile for restore ?
This is solved on raw devices where you need to have the partitions created before you attempt a restore.

Any suggestions ?