RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Controlfile DB Parameters
«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
Backing up control file - Exercise
Oracle Control file backup
Backing up a control file
Objective:
Back up your control file to trace.
Exercise scoring
This is an auto-scored exercise. You will receive 10 points for completing it.
Background/overview
You know that it is important to maintain current backups of your database control files. You also know that those backups should reflect the most recent structural changes to your database. You have just finished adding data files to a tablespace to make room for a fast-growing table. You now want to back up the control file to cover yourself in case a massive drive failure causes you to lose all the online control files.
Instructions
Connect to your database as the
SYSTEM
user, or as any other user having the
ALTER DATABASE
system privilege, and back up your control file to trace.
Hints
The command to use is:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Do not forget that like any other SQL statement, you must end this command with a semicolon.
Submitting your exercise
This is an auto-scored exercise. When you are finished, click the
Submit
button to receive full credit.