everythingOracle.bizhat.com

 

'Everything you wanted
to know about Oracle'

Training References Syntax Tell A Friend Contact Us

 

 

DBA Fundamentals

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
<< Previous

Chapter # 44

Next >>


 

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@yourhost
 

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
 

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';

     Reviews and Templates for FrontPage
     

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