Home » RDBMS Server » Server Administration » Incremental checkpoint and SCN (11.2.0.1 )
Incremental checkpoint and SCN [message #541717] Thu, 02 February 2012 00:30 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Hi,
I am getting messages of incremental checkpoint in my alert logs with some scn.
Completed checkpoint up to RBA [0x125de6.2.10], SCN: 445135162445

Does this mean that all dirty blocks which have had their initial changes before this SCN(445135162445) will be written to disk so that instance recovery can begin from the SCN from which checkpoint has completed.Or is it the other way like the incremental checkpoint has occured at scn 445135162445.

Sekar
Re: Incremental checkpoint and SCN [message #541727 is a reply to message #541717] Thu, 02 February 2012 01:10 Go to previous message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Does this mean that all dirty blocks which have had their initial changes before this SCN(445135162445) will be written to disk so that instance recovery can begin from the SCN from which checkpoint has completed.


Yes.

Regards
Michel
Previous Topic: Unable to increase the size of sga
Next Topic: Oracle database Configuration Assistant Failure
Goto Forum:
  


Current Time: Thu Apr 25 15:33:35 CDT 2024