After you press Refresh from the previous section. If you receive the login window again, enter user sys and password oracle as SYSDBA and click Login.

Click the Maintenance tab.

Under Oracle Secure Backup, click Oracle Secure Backup Device and Media.

Enter /usr/local/oracle/backup for the Oracle Secure Backup Home, admin for the Username and oracle for the password. Then click OK.

Enter your host credentials and click OK.

Under the heading Resources, select the Manage link next to Devices.

1.

You need to insert your volume. Select Insert Volume from the list of Actions and click Go.

2.

For Source type, click This is an unlabeled tape and scroll down to the bottom of the page.

3.

Enter 1-4 in the Storage Element. Then click OK

4.

To see all your devices, click Expand All.

5.

You want to make sure you can access your devices. Select Verify Connectivity from the list of Actions and click Go.

6.

You can access your devices. Now you can create a Backup Storage Selector. Click the Database tab.

Click the Maintenance tab.

Under Backup/Recovery Settings, click Backup Settings.

Scroll down to the Oracle Secure Backup section.

Click Configure. Even though you defined your Administrative Server, you need to associate it with this database.

Make sure your Administration Server is selected from the list. Make sure your host username and password are correct. Then click OK.

Click Add.

7.

Click each Database Backup Type. Then under Use Devices click Add.

8.

Select vt1 and click Select.

9.

Select your vt1 device again and click OK.

10.

Your Backup Storage Selector has been created. Click Return.

11.

Make sure your host credentials are set and then click OK.

Click Schedule Backup.

Make sure your host credentials are set to oracle/oracle and click Schedule Oracle-Suggested Backup.

Choose Both Disk and Tape and then click Next.

Select option Archivelogs and the Full Database Copy, and click Next. Typically you would perform this on a weekly basis however, in this tutorial, you need to perform a backup now so that you can perform the rest of the steps in this tutorial.

Set the time so that it will run within the next 5 minutes. Look at the VM Image time in the upper right of the screen, and choose the next time available. Be sure to set AM or PM correctly. Then click Next.

Click Submit Job.

Your job has been submitted successfully. Click View Job.

Click the browser's Reload button until log names appear in the log list at the bottom of the page. When the Backup log name appears, click on it.

Scroll to the bottom and see the progress. Keep hitting Reload until you see the progress. This will take several minutes to complete. When complete, click the Database link at the bottom of the window.

From Enterprise Manager, click Administration tab.

Select Tables.

Enter HR in the Schema field and click Go.

Select the Employees table, select View Data from the list of Actions and click Go.

The list of Employees is displayed. Click the Database breadcrumb.

Select Tablespaces.

Select the EXAMPLE tablespace, select Take Offline from the list of Actions and click Go.

Click Immediate for the Offline Mode and click OK.

Your tablespace is now offline. Click the Database link.

Since the tablespace is offline, you can now delete the file. Open a teminal window and execute the following commands:

cd $ORACLE_BASE/oradata/orcl
rm example01.dbf

You want to verify that the data is not available any longer. Switch back to Enterprise Manager and select the Tables link.

Enter HR in the Schema field and click Go.

Select Departments, select View data from the list of Actions and click Go.

Note the I/O error. The data file contents are no longer there. Click the Database breadcrumb.

Click the Maintenance tab.

Under Backup/Recovery, select Perform Recovery.

Note the database information stating that there is one data file that needs recovery. Click Datafiles Need Media Recovery.

The data file to restore is already in the data file list. Click Next.

Take the default settings for restoring to the default location, and click Next.

Review the job to be submitted, and note that you can click Edit RMAN Script to view the script that will be run. Click Submit.

The browser continues to poll for status on the restore request. After about a minute, an "Operation Succeeded" message appears, at which point you should click OK.

Click the Administration tab.

Click Tablespaces.

Select the EXAMPLE tablespace and select Place Online in the list of Actions, then click Go.

Click Yes to confirm.

Your data file for the EXAMPLE tablespace has been placed online again. Click the Database breadcrumb.

Select Tables.

Enter HR in the Schema field and click Go.

Select the Employees table, select View Data from the list of Actions and click Go.

The list of Employees is displayed. Click the Database breadcrumb.

Select Tablespaces.

Select the EXAMPLE tablespace, select Take Offline from the list of Actions and click Go.

Click Immediate for the Offline Mode and click OK.

Your tablespace is now offline. Click the Database link.

Since the tablespace is offline, you can now delete the file. Open a teminal window and execute the following commands:

cd $ORACLE_BASE/oradata/orcl
rm example01.dbf

Switch to your terminal window and execute the following commands:

cd $ORACLE_BASE/flash_recovery_area/ORCL/datafile
rm *example*.dbf 

You want to verify that the data is not available any longer. Switch back to Enterprise Manager and select the Tables link.

Enter HR in the Schema field and click Go.

Select Departments, select View data from the list of Actions and click Go.

Note the I/O error. The data file contents are no longer there. Click the Database breadcrumb.

Click the Maintenance tab.

Under Backup/Recovery, select Perform Recovery.

Note the database information stating that there is one data file that needs recovery. Click Datafiles Need Media Recovery.

The data file to restore is already in the data file list. Click Next.

Take the default settings for restoring to the default location, and click Next.

Review the job to be submitted, and note that you can click Edit RMAN Script to view the script that will be run. Click Submit.

The browser continues to poll for status on the restore request. After about a minute, an "Operation Succeeded" message appears. Scroll down to see what was recovered.

Notice that the backup datafile was not found so the tablespace was recovered from tape. Click OK.

Click the Administration tab.

Click Tablespaces.

Select the EXAMPLE tablespace and select Place Online in the list of Actions, then click Go.

Click Yes to confirm.

Your data file for the EXAMPLE tablespace has been placed online again. Click the Database breadcrumb.

Select Tables.

Enter HR in the Schema field and click Go.

Select the Employees table, select View Data from the list of Actions and click Go.

The list of Employees is displayed. Click the Database breadcrumb.

From your browser window, click the Maintenance tab.

Under Oracle Secure Backup, right-click on File System Backup and Restore and click Open Link in New Window.

Click OK to connect with a certificate. The reason you get this warning is because the signer of the certificate is not trusted. Your browser does not recognize the signer as a registered CA, certificate authority. The only trusted CAs that come with each browser are Thwart and Verisign.

Enter admin for the User Name and your Secure Backup password and click Login.

You can view the backup job you just ran in Enterprise Manager. Click the Completed Jobs link.

You see the jobs you performed in Enterprise Manager. At this point, you want to perform your file system backup. Click the Backup tab.

Under Settings, click Datasets.

Click Add.

Enter wkdir for the Name and add your hostname to the include path so it now reads include path <hostname>. Then scroll down.

In this scenario, you want to backup just the /home/oracle/wkdir/obdir/dir2 directory. So later in the tutorial you restore only the dir2 directory. Change/Add the following:

include path /home/oracle/wkdir/obdir {
exclude path /home/oracle/wkdir/obdir/dir1. 

Then click Save.

Click wkdir from the list of Datasets and click Check Dataset.

No errors were found. Click Close.

Now you are ready to perform your backup. Click the Backup breadcrumb.

Under Operations, click Backup Now.

You first need to add your dataset. Click Add.

Select the Dataset wkdir and the Restriction vt1 and click OK.

Select your dataset from the list and click Go.

Click the Home tab.

Click the Completed Jobs.

Your backup is now complete. You can take a look at the transcript if you want. Otherwise, you are ready to restore from backup.

From your terminal window, enter the following commands to see the present state of the directories and then to delete them.

cd /home/oracle/wkdir/obdir
ls -lR
rm -Rf * 

Note that there are 2 sub-directories, and one of them has a file named core. After the restore you will see only the dir2 directory and the files file3.txt and file4.txt in the list. This is because when you performed the backup you excluded the path for dir1 and any files with the name core.

Switch back to your browser, and click the Restore tab.

Click Backup Catalog under the Operations heading.

Select your hostname and click Browse Host.

Click on the "home/" link.

Continue to navigate down into the directory until "obdir/" appears as the directory link. Click to turn on the checkbox for the obdir directory. Then click Add.

Keep the defaults, which restore all files unless they are in use. Click OK.

Note the "Success" message saying the selection was added to the restore list. Click "Show restore list and browse options" link.

Note that the obdir directory is in the list. Select it and click Go.

Note the "Info" message saying the job was submitted. Click Home.

Click Completed Jobs.

Switch to your terminal window and enter the following commands to see the results of the restore:

cd /home/oracle/wkdir/obdir
ls -lR

Note that directory dir2 has been restored, but not dir1. Also note that the file core has not been restored. This was as a result of the exclude path and name entries you set during the backup.

From Enterprise Manager, click Recovery Settings from the Maintenance tab.

Deselect ARCHIVELOG Mode and click Apply.

You need to restart the database for the changes to take affect. Click Yes.

Enter your host username and password and enter sys and its password and connect as SYSDBA. Then click OK.

Click Yes.