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: 183
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,

Report message to a moderator

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: 68648
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

Report message to a moderator

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: 4579
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.

Report message to a moderator

Previous Topic: BACKUP FROM DAILY INCREMENTAL COPY WITH FULL WEEKLY BACKUP
Next Topic: active data guard
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 04 20:51:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.