Oracle Backup Recovery
Backup Recovery Features
Recovery Manager Features
Oracle Backup Strategies
Recovery Manager Enhancements
RMAN Format Parameter
Executing Backup Scripts
Control File Character
Line Command RMAN
Perform Tablespace Recovery
Perform Database Recovery
Backup Recovery Strategies
Fast-Start Recovery Components
Understanding Faststart Checkpointing
Faststart Ondemand Rollback
Implement Faststart Parallel Rollback
Backup Recovery Improvements
Oracle Export Import
Duplex Multiple ArchiveLogs
Repairing Corrupted Blocks
Database Backup Reports
Data Dictionary Views
Backup using OEM
Configuring OEM to Use RMAN
Schedule using backup Wizard
Perform Tablespace - Exercise
Perform tablespace recovery with line command RMAN
Course Project: Restoring a tablespace
Restore a tablespace by using RMAN.
This exercise is worth a maximum of 10 points.
In this exercise, you will use RMAN to restore tablespace CUSTOMER to the disk.
Review the fact file to find out more information about the House-O-Pets and its Oracle 8i database.
Click the View Table link below to see the contents of the tables in the House-O-Pets database.
When performing routine maintenance of the House-O-Pets database, the DBA accidentally drops a table from the CUSTOMER tablespace. The only way to restore a table inside the Oracle Database is by using a tablespace recovery.In this exercise, you are required write the code string to restore tablespace CUSTOMER to the disk.
Write script that restores tablespace CUSTOMER to the disk.
Additional questions to consider:
When you have submitted your code, answer the following question: How does a recovery catalog affect the recovery process?
Submitting your Exercise
Type (or cut and paste) your plan into the box below to submit your answers.
button when finished to submit the exercise.Remember to submit all of your answers at once.