Hands-On 06 (RMAN-Managed Complete Backup)

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 LIST BACKUP command

Commands:

            DOS> rman CATALOG

            RMAN> BACKUP DATABASE

            RMAN> LIST BACKUP;

            RMAN> exit;

-- Hands-On 06 (RMAN-Managed Complete Backup)
-- Preparation
SET ECHO ON

SET linesize 1000 pagesize 55
COL name FORMAT a30
col description format a30
pause

CLEAR SCR
-- 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.

pause


CONNECT system/manager@school

pause

CLEAR SCR
-- 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
pause
pause

CLEAR SCR
-- This is one way you can do the complete database backup.
-- Notice that the default backup destination is %ORACLE_HOME%\database.

--\/-- rman> RUN
--\/-- {
--\/-- ALLOCATE CHANNEL mybackup TYPE disk;
--\/-- BACKUP DATABASE;
--\/-- }
--\/-- -OR- rman> BACKUP DATABASE;
pause
pause

CLEAR SCR
-- Or you can perform a complete RMAN backup database and
-- store the backup in the RMANBKUP directory with stampdate,
-- 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.

-- Please wait since this will take some time.
-- We are going to pause the movie and start it when the backup process
-- is completed.

--\/-- RMAN> BACKUP DATABASE FORMAT 'c:\RMANBKUP\full_%T_%s_%p';
pause
pause

CLEAR SCR
-- Verify the complete or full backup by issuing the LIST BACKUP command.
-- rman> LIST BACKUP;
pause
pause

-- Exit from the recovery manager.
-- rman> exit;
pause
pause

CLEAR SCR
-- Now, you should practice this Hands-On exercise.

-- For more information about the subject, you are encouraged
-- to read from a wide selection of available books.

-- Good luck.
--
pause
pause