Home » RDBMS Server » Backup & Recovery » oracle - o/s: HP-UX:11.23 (Reason for picking the complete block during backup mode )
oracle - o/s: HP-UX:11.23 [message #376938] Fri, 19 December 2008 04:02 Go to next message
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Dear sir,
I'am generally raising this below question,
During backup mode ( >...BEGIN BACKUP;), the complete block is getting stored in redo buffer and inturn getting saved in redo log files...
Please confirm why the complete block is picked up and stored in redo log file ?
what is the reason ?

thank you,
Re: oracle - o/s: HP-UX:11.23 [message #376941 is a reply to message #376938] Fri, 19 December 2008 04:10 Go to previous messageGo to next message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not but for the first modification after begin backup. Why? Just to get a consistent image of the block in case of backup would not have it (if the block is written at the same it is backed up).

Re: oracle - o/s: HP-UX:11.23 [message #376942 is a reply to message #376938] Fri, 19 December 2008 04:11 Go to previous message
Frank Naude
Messages: 4516
Registered: April 1998
Senior Member
It is required as Oracle might need to reconstruct incomplete/split blocks.

PS: you should convert to RMAN instead of worrying about old problems like this.
Previous Topic: How to recover the fullbackup sets and incremental bkp sets ?
Next Topic: active data guard
Goto Forum:

Current Time: Sat Aug 19 19:28:51 CDT 2017

Total time taken to generate the page: 0.19205 seconds