Archivelog | Noarchivelog   «Prev  Next»

Media recovery with noarchivelog mode - Exercise

Restore the USER tablespace

Objective: Order the steps to restore the USER tablespace This exercise uses a Java applet to allow you to match items in the left column with the items in the right column. If you do not have Java active in your browser or are behind a firewall that does not allow Java applets, you will not be able to complete this exercise. If you do not see the applet below, click OK, I'm Done to continue with the course.

Instructions

Below are 6 steps required to restore the USER tablespace after a disk media failure, but they are presented out of order. Drag the steps into the correct order, with the first step at the top of the list.
When you have the steps in the correct order, click Done. You'll be told whether or not the order is correct. If you didn't get the order right, keep trying. If you get stuck, try clicking Hint. The steps you have in the correct place will have green lights next to them. The steps that are not in the correct place will have red lights next to them. When you're ready for an explanation, click the Submit button.

Exercise Scoring

This exercise is unscored. It is designed to allow you to check your understanding of how to restore the USER tablespace. When you are done, click the Submit button.
  1. svrmgr> connect internal;
  2. svrmgr> startup mount;
  3. svrmgr> alter database datafile 'c:\oracle8\database\usr1orc1.ora' offline drop;
  4. svrmgr> alter database open;
  5. svrmgr> drop tablespace user including contents;
  6. svrmgr> create tablespace user datafile 'c:\oracle8\database\usr1orc1.ora' size 1m;
  1. svrmgr> alter database datafile ‘c:\oracle8\database\usr1orc1.ora’ offline drop;
  2. svrmgr> drop tablespace user including contents;
  3. svrmgr> startup mount;
  4. svrmgr> alter database open;
  5. svrmgr> create tablespace user datafile ‘c:\oracle8\database\usr1orc1.ora’ size 1m;
  6. svrmgr> connect internal;