|
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 YOURDBNAME 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 ORACLE 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.
|
