This video discusses the properties of the Oracle redo logs and how the redo logs help assure the database will remain consistent after restarts or crashes.
- [Instructor] The Redo Log Files…store database change vectors,…which are events that represent modifications done…to database rows and the database table structure.…These Redo records are mainly used…by the Oracle Instance for crash recovery purposes.…Redo Logs are the Oracle name…for the database transaction log.…If you lose your database Redo Log Files,…you lose your database, and won't be able to start it up.…The Oracle database requires at least two Redo Log Files…at any given time, as it writes to them in a cyclic manner.…
Meaning, that the database writes…to the first Redo Log File,…and once that Redo Log File is filled up,…the database will start writing…to the second Redo Log File.…This is called a Redo Log switch.…Once the second Redo Log File was written to,…and is now full,…the database returns and writes back…to the first one, and vice versa.…That's why it's called a cyclic write.…While two is the minimum amount…of Redo Logs an Oracle database requires,…we can, and often should, create more.…
Typically, three, five, or seven Redo Logs are common.…
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 Fundamentals: Core Conceptswith Adam Wilbert2h 14m Beginner
Relational Database Fundamentalswith Adam Wilbert2h 40m Beginner
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
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 58s
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.