Hot backups
Oracle introduced hot backups back in version 6, allowing us take hot backups of our database tablespaces without the need to shut down the database like in earlier versions. Moreover in version 10g, Oracle gave us the ability to take hot backups of the entire database, making our life a little more easy. When executing a user-managed backup online, Oracle stops recording checkpoints to all the associated datafiles.
Let's take a deeper look at what's happening internally in the database when we use the BEGIN BACKUP option:
- A hot backup flag in the datafiles header is set
- A checkpoint occurs, flashing all dirty blocks from memory to disk, synchronizing all the datafile headers to the same SCN, and freezing the headers for consistency, ...
Get Oracle Database 12c Backup and Recovery Survival Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
