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: 64132
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: 4502
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: Wed Dec 07 18:10:23 CST 2016

Total time taken to generate the page: 0.13613 seconds