Hands-On 04 (Using the RMAN backup utility)

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 04 (Using the RMAN backup utility)
-- Preparation
SET ECHO ON
CONNECT system/manager@school AS SYSDBA
HOST ERASE c:\RMANBKUP\*.*

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

--Start

CLEAR SCR
-- In this exercise, you will learn how to perform a
-- backup copy in a specific location, along with 
-- formatting backup's file name, and also backup 
-- the database objects using the incremental syntax.

pause
pause

CLEAR SCR
-- Run the RMAN tool.
--\/-- DOS> RMAN

pause
pause

-- Connect to the RMAN tool using the Recovery Catalog database.
--\/-- RMAN> CONNECT CATALOG RMAN/password@dbs4RMAN
pause
pause

-- Connect to the target database.
--\/-- RMAN> CONNECT TARGET system/manager@school
pause
pause

-- Perform a RMAN backup of datafile 7 and save it in the RMANBKUP
atafile 7 and save it in the RMANBKUP
-- directory with the 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.
--\/-- RMAN> BACKUP DATAFILE 7 FORMAT 'c:\RMANBKUP\file7_%T_%s_%p';
pause 
pause

CLEAR SCR
-- Perform RMAN backup of the tablespace tools.
--\/-- RMAN> BACKUP TABLESPACE tools FORMAT 'c:\RMANBKUP\tools_%T';
pause
pause

-- Perform RMAN backup of the tablespace tools using incremental
-- level 0.
--\/-- RMAN> BACKUP INCREMENTAL LEVEL 0 TABLESPACE tools FORMAT 'c:\RMANBKUP\tools_L0';
pause
pause

-- 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,
-- level 3, and level 4.
--\/-- RMAN> BACKUP INCREMENTAL LEVEL 1 TABLESPACE tools FORMAT 'c:\RMANBKUP\tools_L1';
pause
pause
pause

-- Then exit from RMAN.
--\/-- 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