This video lists the eight different types of files Oracle uses for database storage.
- [Instructor] Congratulations on making it this far in the course. You are probably starting to feel like a true Oracle expert by now. We have actually completed a major part of our course, which is to review the Oracle instance and all of its components. Remember, the Oracle instance is the in-memory half of the Oracle database, running in server RAM, caching data, and processing user requests. The other half, which we'll discuss now in greater details, is the Oracle data storage, or Oracle database files.
The Oracle database storage is the persistent on-disk representation of the Oracle database. Remember, this is where your data actually resides as files on disk. It is from here that the Oracle server processes read data, and it is to here that the Oracle database writer as well as the log writer write modified rows. Want me to tell you a very well-known secret? Oracle database storage isn't made out of one file, or even one type of file.
As you might have already guessed by this point, Oracle maintains different types of file on disk for different purposes. Remember that when we talked about the Oracle instance we mentioned that different caches in memory are used for different types of data. Similarly, Oracle maintains different files on disk for different purposes. What you see on your screen right now are all of the different file types that Oracle utilizes. When you look inside the directory on your storage system where you have configured your Oracle database to reside, you will actually see those files.
Why does Oracle need so many unique types of files? Well, that's a great question. To give you some example, some of those files, such as the data files, store our actual database data. Other files, such as the redo log files, contain a record of all transactions which have been committed so that the Oracle instance can recover successfully if it crashes or restarts. The alert log, on the other hand, is the actual database error log. It is here you will find information regarding various conditions or errors which have occurred while your database has been running.
This is the file you will monitor to make sure your database is operating smoothly, but this is just the tip of the iceberg. Let's start reviewing the Oracle database storage files one by one.
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