everythingOracle.bizhat.com

 

'Everything you wanted
to know about Oracle'

Training References Syntax Tell A Friend Contact Us

 

 

OEM

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17
<< Previous

Chapter # 16

Next >>


 

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.

 

 

     Reviews and Templates for FrontPage
     

Copyright � everythingOracle.bizhat.com 2006 All Rights Reserved.