Backup Mode [message #473497] |
Sun, 29 August 2010 11:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
subbu_tce
Messages: 98 Registered: July 2007 Location: pune
|
Member |
|
|
Hi,
My Tablespace is in backup mode.Now am issuing alter system checkpoint.will the dbwr writes the dirty blocks in datafiles.
If so,how it will update the scn becuase i havn't issued end backup still.Plz clarify me on this.
|
|
|
|
Re: Backup Mode [message #473529 is a reply to message #473497] |
Mon, 30 August 2010 01:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Yasir Hashmi
Messages: 304 Registered: April 2006
|
Senior Member |
|
|
Hi,
The file would not be checkpointed.It was already checkpointed by a tablespace checkpoint when you put it in begin backup mode so header is freezed. The file would be available for normal operations but no checkpoint info would be recorded in its header until you put it in end backup mode.
|
|
|
|
|
|
|
Re: Backup Mode [message #473545 is a reply to message #473544] |
Mon, 30 August 2010 03:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
I mean during checkpoint after begin backup, DBWR still does the checkpoint (write the buffers for the tablespace) but CKPT does not (does not update the file header).
Regards
Michel
[Updated on: Mon, 30 August 2010 03:17] Report message to a moderator
|
|
|
|