Yes,

I'm going to speak off the top of my head, and disclaim up front some
may not be exactly correct.

Assuming you are speaking of user defined backup (tblsp begin, end
backup), datafiles are continued to be updated by DBWR as normal.
There are pointers marking when the backup state began. I believe these
poinsters are in the redo logs. then when you are done and issue the
alter tblsp end backup the pointers are moved forward to present
indicating back in business. This is why the database does not take
such a big hit. So while the copy is going on, the datafiles represent
a consistent state.

Well, I'd look it up if I wanted to jog my memory exactly, but it is you
question, and you have that option as well.


Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: m [mailto:oracledba-ezmlmshield-x54519511.[Email address protected]

Sent: Thursday, November 02, 2006 4:56 AM
To: LazyDBA Discussion
Subject: Hot Backup mode

Hi Gurus !!!!

Does Oracle write to a datafile which is in Backup Mode..? Why does
Logging increases during hot backup..?


Manish Misra
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page