hotbackup [message #150949] |
Mon, 12 December 2005 03:44 |
risy_s
Messages: 44 Registered: September 2005 Location: Mumbai
|
Member |
|
|
hi all
can anybody tell me about this
when i put my tablespace in hotbackup mode scn will be frozen in header of the datafile so if any user will chnge anything to that datafile change will happen but scn will not move ahead.... so my que. is if v have done some changes in datafile during hot backup mode...how can i get that changes after my ts is out of hotbackupmode
i mean to say how oracle will update datafile aftrer ending hot backup
Thank you
risy...
|
|
|
Re: hotbackup [message #150956 is a reply to message #150949] |
Mon, 12 December 2005 05:06 |
tarundua
Messages: 1080 Registered: June 2005 Location: India
|
Senior Member |
|
|
from the forum
Does Oracle write to data files in begin/hot backup mode?
Oracle will stop updating file headers, but will continue to write data to the database files even if a tablespace is in backup mode.
In backup mode, Oracle will write out complete changed blocks to the redo log files. Normally only deltas (changes) are logged to the redo logs. This is done to enable reconstruction of a block if only half of it was backed up (split blocks). Because of this, one should notice increased log activity and archiving during on-line backups.
|
|
|