Originally posted by Sonia
Hi,
Whenever a tablespace is in hot backup mode, Oracle logs the entire image of the block into the Online redolog files.
Not quite. When a datafile is in hot backup mode, Oracle logs the entire image of the changed block into the Online redolog files only the first time this block is changed since the beginning of the hot backup mode. Any subsequent changes of that same block while the datafile is in backup mode will result only in change vectors being written to the redo log files, exactly the same way as when the datafile is not in backup mode.
My question is does oracle logs the image before it is changed or after the block is changed ?...
Redo logs record only the after-the-change informations.
and one more question is, when i add a new datafile to the Tablespace which is in hotbackup mode is this datafile also in backup mode ?...
No, the new datafile will not be in backup mode.
what abt the blocks or extents which get allocated to this datafile ??
What about them??