iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

DBAs - OEM

 

Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 |

 

Lesson 16

"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:

   OEM-VIDEO -Performing a logical backup and restore

   

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.