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

Control file backup

Having a valid backup of the control file of a database is crucial for the successful recovery of a database. Due to this we will take a closer look at the available methods to make a user-managed backup of a control file.

Tip

Always do a backup of the control file after making a structural change to a database operating in the ARCHIVELOG mode such as creating, deleting, or modifying a tablespace, due that this new information will not be available on previous backups of the control file.

Binary backup

You can generate a binary copy of the control file via a simple SQL statement. A binary copy of the control file contains additional information such as the archived redo log history, offline range for read-only and offline tablespaces, ...

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