|
"The man who
does not read good books has no advantage over the man who
cannot read them." - Mark Twain (1835-1910) |
Read
first then play the video:
OEM016(VIDEO)-Performing
a logical backup and restore
You must first Register
and then request for username and password
to access to VIDEOS
Performing a logical backup
and restore
Introduction
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:
Covers:
Using the “Database
Wizards” tool
Using the “Export Wizard”
tool
Specifying a backup table
Scheduling a Job
Adding created export jobs
to the Job Library
Using the “Import Wizard”
tool
Specifying a restore table
Scheduling a Job
Adding created import jobs
to the Job Library
Viewing created Jobs in the
Job Library
Hands-on
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).
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.
|
