Home » RDBMS Server » Backup & Recovery » oracle - 9.2.0.8.0 o/s: HP-UX:11.23 (Reason for picking the complete block during backup mode )
oracle - 9.2.0.8.0 o/s: HP-UX:11.23 [message #376938] Fri, 19 December 2008 04:02 Go to next message
kesavansundaram
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 - 9.2.0.8.0 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: 64948
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).

Regards
Michel
Re: oracle - 9.2.0.8.0 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: 4509
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: BACKUP FROM DAILY INCREMENTAL COPY WITH FULL WEEKLY BACKUP
Next Topic: active data guard
Goto Forum:
  


Current Time: Fri Jun 23 05:29:36 CDT 2017

Total time taken to generate the page: 0.08986 seconds