Hands-On 16 (Performing a logical backup and restore)

As a DBA, you are responsible for performing a logical backup and restoration of your organization’s database in case of a disaster. The following is a summary of your assigned task:

1. Using the “Database Wizards” tool

2. Using the “Export Wizard” tool

3. Specifying a backup table

4. Scheduling a Job

5. Adding created export jobs to the Job Library

6. Using the “Import Wizard” tool

7. Specifying a restore table

8. Scheduling a Job

9. Adding created import jobs to the Job Library

10. Viewing created Jobs in the Job Library

Hands-On 16 (Performing a logical backup and restore)

Description:

In this exercise you will learn how to schedule a logical restore
and backup of an entire database, users, or tables from IMPORT and
EXPORT utilities using the Oracle Enterprise Management tool (OEM).

==Start.
Expand the databases.

==
Select the SCHOOL database.

==
Go to the "Database Wizards" tools and click on the "Export" icon
to schedule a logical backup.


==
On the "Export Wizard" window, click NEXT.

==
Specify an export dump file on the server and click next.

==
Choose the "Table" export type and click NEXT.

==
Expand the ISELF schema and select your tables, then click NEXT.

==
Specify all the associated objects to your tables and click NEXT.

==
Specify the date and time you want to export the table and click NEXT.

==
Specify the name and description for the job and do not submit the job
now, but add it to the job library for later use and click NEXT.

==
On the "Summary" window, check the EXPORT parameter.
If it looks good, click Okay.

==
The job has been added to the Job Library to run on Friday.

==
On the "Job" menu, select the "Job Library" item.

==
This is the export job.
Now, close the window.

==
Go back and click on the "IMPORT" icon to schedule a logical restore.


==
On the "Import Wizard" window, click NEXT.

==
Specify the exported file and we will manually specify the table we
want to import.

Click Next.
==
On the "Import Type" form, specify the table and the schemas that 
the table will be imported into. Then click NEXT.

==
In the "User Mapping" form, import the table into the same user's schema.
Then, click NEXT.

==
Specify the associated object and click NEXT.

==
Specify the date and time you want to import the table and click NEXT.

==
Specify the name and description, and do not submit the job now, but
add it to the job library for later use.

==
In the "Summary" window, check the IMPORT parameter.
If it looks good, click okay.

==
The job has been added to the Job Library to run on Saturday.

==
In the "Job" menu, select the "Job Library" item.

==
These are the EXPORT and IMPORT jobs.

Click on the Export job and browse through the job's Task, Parameters, 
and other information.

Now, the EXPORT job will backup the CUSTOMER table on Friday and the IMPORT job
will restore the CUSTOMER table on Saturday.

For more information about the subject, you are encouraged
to read from a wide selection of available books.

Good Luck!