Session ID: 752


From day 1 everyone states the controlfile is important - and should be protected. Make sure you have more than one copy, why not three... So what is this controlfile? Did you know that it hosts a lot of valuable information about the database and plays an important role in backup and recovery? Whether you are running in the could, on-premise or a hybrid solution. In this session we will take a closer look at the Oracle Database 12c Controlfile, with more focus on it from a backup and recovery point of view. This will include gaining a better understanding of the dreaded "File 1 needs more recovery to be consistent" or " File 1 was not restored from a sufficiently old backup" - what does these mean and what the next possible steps are.

Objective 1: Review the ORA-01194, ORA-01547, ORA-01152 error messages, and gain an understanding of what these error messages mean and why you are getting them?

Objective 2: Learn more about the controlfile, checkpoints and the datafile header

Objective 3: Gain a better understanding of some key backup and recovery concepts

Audience: In-Depth