Transactions During Hot Backup

Where will the transactions be stored during Hot Backup?

During hot backup we specify the tablespace during beginning backup mode and now if a user perform some transactions then where such transactions are stored?

Questions by satish220

Showing Answers 1 - 7 of 7 Answers

abdul_dy

  • Jun 15th, 2012
 

In HOT backup mode users transaction/data is goes in their respective default tablespaces only since the datafile header will not update til the time you end the backup mode

  Was this answer useful?  Yes

Divakar

  • Oct 31st, 2014
 

During hot backup, once we issue the Begin Backup command respective datafile header will be freezed, if users performs transaction it will be stored in the datafiles but the SCN # will not updated as the datafile header is freezed. Once we issue the END BACKUP command the recent SCN# from redo logs will be updated in the datafile header.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions