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