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

Using the CONTROLFILE_RECORD_KEEP_TIME parameter

A control file, as the name suggests, is just a file and is made at the time of the database creation with a finite size. The size of a control file is mainly based on the following parameters:

  • MAXDATAFILES
  • MAXINSTANCES
  • MAXLOGFILES
  • MAXLOGMEMBERS
  • MAXLOGHISTORY

The initial size of the control file is determined based on the values of these parameters. To accommodate subsequent changes to these parameters after the database creation, the control file will be expanded dynamically. Unlike the default block size (determined by the DB_BLOCK_SIZE parameter), the block size of a control file will be fixed and hardcoded for a specific database release; for database release 12c, it is fixed for 16 KB. You can check ...

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