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 - Fundamentals II

 

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 17 | Lesson 18 | Lesson 19 | Lesson 20 | Lesson 21 | Lesson 22 | Lesson 23 | Lesson 24 | Lesson 25 | Lesson 26 | Lesson 27 | Lesson 28 | Lesson 29 |

 

Lesson 17

“If this is coffee, please bring me some tea; but if this is tea, please bring me some coffee.” Abraham Lincoln

 

Read first then play the video:

   DBA-VIDEO -Using the RMAN backup utility

   

Using the RMAN backup utility

 

Introduction

As a DBA, you are also responsible for performing backups of a database, performing incremental backups, and using the formatted defined output name. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

 

Performing a backup copy in a specific location

Performing a backup with formatting the backup file’s name

Backing-up database objects using the incremental syntax

Using the %T for the date

Using the %S for the backup set number

Using the %P for the piece number

Performing a RMAN backup of a tablespace

Performing RMAN backup of a tablespace

Incremental

Performing a RMAN backup of a tablespace

Incremental

Commands:

DOS> RMAN

RMAN> CONNECT CATALOG

RMAN> CONNECT TARGET

RMAN> BACKUP DATAFILE

RMAN> BACKUP TABLESPACE

RMAN> BACKUP INCREMENTAL

RMAN> exit

 

Hands-on
In this exercise, you will learn how to perform a backup copy in a specific location, along with formatting backup's file name, and alsobackup the database objects using the incremental syntax.

Run the RMAN tool.
DOS>RMAN

Connect to the RMAN tool using the Recovery Catalog database.
RMAN>CONNECT CATALOG RMAN/password@dbs4RMAN

Connect to the target database.
RMAN>CONNECT TARGET system/manager@school


Backup a datafile in an specific location
Perform a RMAN backup of datafile 7 and save it in the RMANBKUP
datafile 7 and save it in the RMANBKUP directory with the stamp date, the backup set number, and the piece number. Notice that we use %T for the date, %s for the backup set number, and %p for the piece number.
RMAN>BACKUPDATAFILE 7 FORMAT 'c:_%T_%s_%p';


Backup a tablespace in an specific location
Perform RMAN backup of the tablespace tools.
RMAN>BACKUPTABLESPACE tools FORMAT 'c:_%T';


Incremental Backup
Perform RMAN backup of the tablespace tools using incremental level0.
RMAN>BACKUP INCREMENTAL LEVEL 0 TABLESPACE tools FORMAT 'c:_L0';

Perform a RMAN backup of the tablespace tools using the incremental level 1. Notice that you do the same thing to backup the whole database incrementally. - The incremental backup levels are denoted as level 0, level 1, level 2, level3, and level 4.
RMAN>BACKUP INCREMENTAL LEVEL 1 TABLESPACE tools FORMAT 'c:_L1';

Then exit from RMAN.
RMAN>exit

 

“Do not worry about your difficulties in Mathematics. I can assure you mine are still greater.” Albert Einstein

 

Questions:

Q: How do you perform a backup in a specific location?

Q: What is the formatting the backup file’s name?

Q: How can you backup database objects using the incremental option?

Q: What do the following formatting name syntaxes mean?

%T for the date

%S for the backup set number

%P for the piece number

Q: What do the following RMAN commands do?

DOS>RMAN
RMAN>BACKUPDATAFILE 7 FORMAT 'c:_%T_%s_%p';

RMAN>BACKUPTABLESPACE tools FORMAT 'c:_%T';

RMAN>BACKUP INCREMENTAL LEVEL 0 TABLESPACE tools FORMAT 'c:_L0';
RMAN>BACKUP INCREMENTAL LEVEL 1 TABLESPACE tools FORMAT 'c:_L1';