This video discusses how the control files are used to store the physical locations of making up the Oracle database.
- [Instructor] Now it's time to discuss the purpose of the Oracle Database Storage Control File. Each Oracle database has a unique control file that contains data about the database itself. Sounds funny, but I'm not kidding. The control file contains information about the physical properties of the database, properties such as the database names, names and locations of the data files and redolog files which belong to this database, checkpoint information, to name a few.
By the way, by names and locations of data files and redolog files, I mean that the control file actually stores the complete path of where the data files and redolog files exist on disk. When an Oracle instance starts up, it will need to know the location of the control file in order to know where the data files and redolog files are located. Only after the database instance has read the control file it will be able to read the data files and redolog files and continue with its normal startup sequence.
Oracle has built-in support for control file multiplexing. Multiple identical copies of the control file may be maintained to protect against loss of the database. Remember, without the control file, the database instance won't know where to look for the redolog files and the database files, so the control files are essential for database startup. And the best thing about control file multiplexing? We don't have to do it ourselves. Oracle will take care of it for us. We can just instruct the Oracle database to maintain multiple copies of our control files, preferably in multiple locations, and Oracle will take care of the rest.
Because of the critical nature of control files, they are also very important from a backup perspective. Every time you back up your database, be sure to back up your database files, redolog files, as well as your control files. They are all required for the Oracle instance to start up successfully.
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 55s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.