>
Naming Archive Log Files - Exercise
RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Archiving Redo log
«Prev
Next»
DBA Taks
Database Monitoring
Control File Parameters
Protecting Control Files
Removing Control File
Add Control File
Backingup Control File
Recreating Control Files
Checking Parameter Values
v Parameter Dynamic
Changing DB Parameters
Managing DB Parameters
Managing Redo Log
Protecting redoLog Files
Listing RedoLog Files
Create Redo Log Files
Dropping Redo Log Files
Moving Redo Log Files
Manually Switch Log Files
Managing RedoLog Conclusion
Redolog Files
archivelog-mode
archive-log-destination
naming-archive-log-files
manually-archiving-log-file
archive-log-history
archivelog-mode-conclusion
Manage Tablespace Files
Naming Archive Log Files - Exercise
Archivelog mode
Objective:
Turn on archivelog mode for the COIN database.
Exercise scoring
This is an auto-scored exercise worth 20 points.
Background/overview
You have recently constructed a new database named COIN, and have created the necessary tables and indexes for your client's application. Your client requires absolute protection from data loss in the event that a drive goes down or a file is otherwise lost. To provide that protection, you must run the database in archivelog mode.
Instructions
Place the COIN database into archivelog mode. While you are doing this, also take the time to set the archive log destination and to specify the format to use for naming archived log files.
Hints
Follow the steps presented in Lesson 2 for placing a database into archivelog mode, and also remember to set the parameters discussed in the most recent two lessons that control the archive log destination and filename format.
Submitting your exercise
This is an auto-scored exercise. Click the Submit button when you are finished to receive full credit.