Australia/Sydney
BlogOctober 4, 2010

What is exactly stored in an archived redo log ?

Fahd Mirza
Archived redologs are one of the most important distinguishing feature of Oracle. They are the most basic component and an essential part of any production and self-respecting database.

They are used everywhere. From media recovery to log miner, and from standby database to golden gate.

What exactly do they contain?

They store, redo records, composed of change vectors describing changes made to database blocks. Each change vector describes a single transactional change to a database block. Each change vector is marked by a unique number called as System Change Number (SCN). Change vectors also are stored for changes to the rollback segment data blocks and the transaction table of the rollback segments.
Share this post:
On this page

Let's Partner

If you are looking to build, deploy or scale AI solutions — whether you're just starting or facing production-scale challenges — let's chat.

Subscribe to Fahd's Newsletter

Weekly updates on AI, cloud engineering, and tech innovations