This video presents the four different modes for shutting down the Oracle database and describe the differences between them.
- [Instructor] We have a similar story…for shutting down the Oracle Instance.…Going from a running database state to a ...…Well, not running.…We have several methods or modes…of database shutdown you can use.…These different modes determine how cleanly…is the database shutdown procedure performed,…compared to the time it will take.…Starting off with the SHUTDOWN ABORT command.…If we run the SHUTDOWN ABORT command,…it will take the Oracle database from an open, or on state,…to an off state immediately.…
However, because of its brute-force nature,…the database will not be consistent upon shut down.…And when you will restart the database,…Oracle will have to use the redo log files…to perform automatic crash recovery.…It is similar to pulling the plug of the Oracle database.…That might sound scary, but as long as you don't have…any corruptions in your database data files…or missing redo logs, you should be okay.…The SHUTDOWN ABORT mode is usually used when there is…no other method of shutting down the instance that works.…
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.