DBA Fundamentals

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:

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

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

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-

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.

Verify Backup
Verify the complete or full backup by issuing the LIST BACKUP command.
rman> LIST BACKUP;

Exit from the recovery manager.
rman> exit;
 

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?

rman> LIST BACKUP;