O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring the snapshot control file

It is common knowledge that data files can be backed up when the database is open. This option is called the hot backup or open database backup. It is possible because even when the files are being constantly modified and are inconsistent, they can be made consistent by using archived log files in the recovery stage. Creating a consistent file is imperative as otherwise the database can't be opened. Archived logs are self-contained anyway, so taking their backup with an open database is not an issue. However, in the case of the control file that always gets updated, a hot backup of it won't be usable at all. This presents an interesting issue, but fortunately, a solution to tackle it is available with RMAN ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required