"The test of our
progress is not whether we add more to the abundance of those
who have much; it is whether we provide enough for those who
have too little." Franklin D. Roosevelt |
Read
first then play the video:
DBA-VIDEO -RMAN
Managed Complete Backup
RMAN-Managed Complete
Backup
Introduction
As a DBA, you are also
responsible for performing complete backups using the RMAN tool. Your
job"s responsibilities dictate that you should at least be informed
of the following basic fundamental subjects:
Performing a complete
database backup
Using the LIST BACKUP
command
Commands:
DOS> rman CATALOG
RMAN> BACKUP DATABASE
RMAN> LIST BACKUP;
RMAN> exit;
Hands-on
In this exercise you will
learn how to perform a complete FULL database backup using the RMAN
tool.
Now, connect to the SCHOOL database as the SYSTEM/MANAGER user.
SQL> CONNECT system/manager@school
Go back to the RMAN tool and connect to the SCHOOL database as the
target database and the RMAN database as a repository.
DOS> rman CATALOG rman/password@dbs4rman TARGET system/manager@school
Perform a complete backup
The following is one way
you can do the complete database backup. Notice that the default
backup destination is %ORACLE_HOME%.
rman>
RUN
{
ALLOCATE CHANNEL mybackup TYPE disk;
BACKUP DATABASE;
}
-OR-
rman> BACKUP DATABASE;
Perform a complete backup
in an specific location
Or you can perform a complete RMAN backup database and store the
backup in the RMANBKUP directory with 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> BACKUP DATABASE
FORMAT 'c:_%T_%s_%p';
Verify Backup
Verify the complete or full backup by issuing the LIST BACKUP
command.
rman> LIST BACKUP;
Exit from the recovery
manager.
rman> exit;
"I don't care what
is written about me so long as it isn't true." Dorothy Parker |
Questions:
Q: How do you perform a
complete database backup using the RMAN tool?
Q: Describe the LIST BACKUP
command.
Q: What do the following
RMAN commands do?
DOS> rman CATALOG rman/password@dbs4rman
TARGET
system/manager@school
rman>
RUN
{
ALLOCATE CHANNEL mybackup TYPE disk;
BACKUP DATABASE;
}
rman> BACKUP DATABASE;
RMAN> BACKUP DATABASE
FORMAT 'c:_%T_%s_%p';
rman> LIST BACKUP;
|