Hands-On 03 (Configuration of the RMAN tool)

You, as a DBA, are responsible for configuring the RMAN repository, performing an image copy, connecting to the target and catalog databases, etc. Your job’s responsibilities dictate that you should be at least informed of the following basic fundamental subjects:

Configuring the RMAN retention policy

Excluding any tablespaces from a backup

Performing an image copy

Using the CONNECT CATALOG

Using the CONNECT TARGET

Performing an image copy of the data file

Using the NOCHECKSUM parameter

Performing an image copy of the current control file

Using a specific backup naming format

Commands:

COPY DATAFILE TO ‘xxx’ NOCHECKSUM;

HOST MKDIR

            DOS> RMAN

            RMAN> CONNECT CATALOG

            RMAN> CONNECT TARGET

            RMAN> CONFIGURE RETENTION POLICY

            RMAN> CONFIGURE EXCLUDE FOR TABLESPACE

            RMAN> COPY DATAFILE

            RMAN> COPY CURRENT CONTROLFILE

            RMAN> exit

-- Hands-On 03 (Configuration of the RMAN tool)
-- 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 connect to RMAN tool
-- with TARGET and CATALOG options, configure the retention policy,
-- exclude any tablespaces from a backup, perform an image copy,
-- and more.

pause
pause

CLEAR SCR
-- Now, let's first create a directory called RMANBKUP and backup 
-- all of the database files, and Controlfiles into that directory.

pause


HOST MKDIR c:\RMANBKUP

-- The RMANBKUP folder was successfully created.

pause

CLEAR SCR
-- Now, run the RMAN tool.
--\/-- DOS> RMAN

pause
pause

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

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


CLEAR SCR
-- Configure the retention policy to have at most, 2 
-- redundant objects.
--\/-- RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
pause
pause

-- Disable the retention policy.
--\/-- RMAN> CONFIGURE RETENTION POLICY TO NONE;
pause
pause

-- Exclude the TOOLS tablespace from any future whole 
-- backup database sets.
--\/-- RMAN> CONFIGURE EXCLUDE FOR TABLESPACE tools;
pause
pause

CLEAR SCR
-- Perform an image copy of the data file 7 and use 
-- the NOCHECKSUM parameter.
--\/-- RMAN> COPY DATAFILE 7 TO 'c:\RMANBKUP\dbf_yymmdd.dbf' NOCHECKSUM;
pause
pause

-- Perform an image copy of the current control file in
-- a specific directory with a specific naming format.
--\/-- RMAN> COPY CURRENT CONTROLFILE TO 'c:\RMANBKUP\ctlfl_yyyymmdd.ctl';
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