| sasi |
Posted: Feb 04, 2006 02:31:11 AM |
Total Post: 59
Joined: Nov, 2005
|
Hi,
Suppose i am taking online Bkp at 5.00PM . I will backup mode.
At same time some users are updated a datafile,at 5.02PM one user is also updating same datafile.
In that backup i will update to that users data are not?
What is interally happening?
PLZ REPLY
sarath |
|
|
pradeep |
| Posted: Feb 07, 2006 06:08:50 AM | |
|
Total Post: 1
Joined: Feb, 2006
|
|
|
|
|
sasi |
| Posted: Feb 07, 2006 10:21:44 AM | |
|
Total Post: 59
Joined: Nov, 2005
|
what is going on Internally
|
|
|
|
|
suprio |
| Posted: Feb 15, 2006 08:44:15 AM | |
|
Total Post: 11
Joined: Sep, 2005
|
yes you can change a datafile when you are in backup mode and internally all the changes are stored in the redolog file. so you should have enough redo space or you should take the file in backup mode when there are less no. of transactions happening in the database.
|
|
|
|
|
srinivasulu |
| Posted: Jun 11, 2006 09:04:52 PM | |
|
Total Post: 2
Joined: Jan, 2005
|
hello venkat,
While you are taking online backup, Users can still be connected to database and work as usual.
When the database is normal mode then only changes made to the database are stored in redo.
but in online backup, the data regarding changes along with the data to be changed is also stored. That is the reason more redo is generated when in online backup mode.
more details can be found on asktom.oracle.com and search for online backups.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |