|
“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:
DBAx15(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';
|
