Home » RDBMS Server » Backup & Recovery » data syncronisation during Hot Backup!!!!!!
icon7.gif  data syncronisation during Hot Backup!!!!!! [message #164449] Thu, 23 March 2006 08:56 Go to next message
gururaajaan
Messages: 5
Registered: December 2005
Junior Member


Dear All,
I came across this question , where many of them gives different opinions.
(ie.)

During hot backup mode of a Tablespace , when a user in giving bulk insert or update ie(DML Operations) accompanied with commit ,
what will happen ???

1. Whether datas will write to redolog file ? Explain

2. Whether datas will be written to respective datafiles on the above tablespace????

3. Whether data will be consistent???

4. What will happen during end backup ....


Many people gives different opinions on this issue.. i hope some one will clarify me....and im really got confused ....


Please clarify....

Regards

Gururajan R


Re: data syncronisation during Hot Backup!!!!!! [message #164452 is a reply to message #164449] Thu, 23 March 2006 09:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/149622/42800/?srch=Tim+Gorman#msg_149622
Re: data syncronisation during Hot Backup!!!!!! [message #164484 is a reply to message #164452] Thu, 23 March 2006 11:10 Go to previous message
gururaajaan
Messages: 5
Registered: December 2005
Junior Member


Dear Mahesh,
Thanks for the Link .... Its really help full.... But still i am looking for further more,...ie. what will happen ...at END BACKUP stage..... still looking... i u can able to clear my further dobts .. please help...

Regards

Gururajan R
Previous Topic: complete recovery
Next Topic: ORA-00959 tablespace 'test' does not exist
Goto Forum:
  


Current Time: Fri Apr 19 00:13:40 CDT 2024