Home » RDBMS Server » Backup & Recovery » Hot Backup issue
Hot Backup issue [message #62042] Mon, 21 June 2004 21:58 Go to next message
ora
Messages: 47
Registered: June 2002
Member
Hi,

I have a doubt, when we issue alter tablespace .. begin backup command to put the tablespace in backup mode then what exactly happens internally.

I know that oracle stop updating the file headers with the checkpoint info, but in the case of checkpoint that dirty buffers get written to the files or not? if not so where it goes? And why oracle generate extra redo in this period?

Please explain me in detail.
Re: Hot Backup issue [message #62053 is a reply to message #62042] Tue, 22 June 2004 05:40 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Hi,

See http://www.orafaq.com/faqdbabr.htm#FILEWRITE -

"Oracle will continue to write to the database data files, even if a tablespace is in backup mode."

"Oracle will write out complete changed blocks to the redo log files. This is done to enable reconstruction of a block if only half of it was backed up (split blocks). Because of this, one should notice increased log activity and archiving during on-line backups."

Best regards.

Frank
Re: Hot Backup issue [message #62057 is a reply to message #62053] Tue, 22 June 2004 20:04 Go to previous message
ora
Messages: 47
Registered: June 2002
Member
Thanx Frank.
Previous Topic: Backup & Recovery Question
Next Topic: how to recover a truncated table
Goto Forum:
  


Current Time: Sat Nov 23 19:28:33 CST 2024