Hands-On 01 (RMAN-Managed user and repository)

You, as a DBA, are responsible to create the RMAN repository and use the RMAN tool to perform a backup and recovery of your organization’s database. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Creating the RMAN user

Generating the RMAN objects

Creating the Recovery Manager Repository

Creating the RMAN tablespace

Granting privileges to the RMAN user

Granting the RECOVERY_CATALOG_OWNER to the RMAN user

Using the RMAN RCVCAT command

Using the DBA_OBJECTS dictionary view

Using the DBMS_RCVCAT package

Using the DBMS_RCVMAN package

Commands:

CREATE TABLESPACE

CREATE USER

GRANT

DOS> rman RCVCAT

RMAN> CREATE CATALOG;

RMAN> exit;

-- Hands-On 01 (RMAN-Managed user and repository)
-- Preparation
SET ECHO ON
connect system/manager@dbs4rman as sysdba
drop user rman cascade;
drop tablespace rman_tablespace including contents cascade constraints;
HOST ERASE c:/newfolder/rman_tablespace_01.dbf

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 create the 
-- RMAN user with all of its objects.

-- You will also learn how to create the Recover Manager
-- Repository.

-- Now, connect to SQLPlus as the SYSTEM/MANAGER user.

pause


CONNECT system/manager@dbs4rman AS SYSDBA

pause


CLEAR SCR
-- Query all of the users in the DBS4RMAN database to 
-- verify whether or not the RMAN user exists.

pause

SELECT username 
FROM dba_users
WHERE username like 'R%'
/

-- It looks like the RMAN user was never created.

pause


CLEAR SCR
-- Create a tablespace and name it RMAN_TABLESPACE
-- with a size of 50 Megabytes with the AUTOEXTEND option.

pause

CREATE TABLESPACE rman_tablespace
DATAFILE 'c:/newfolder/rman_tablespace_01.dbf' SIZE 50M
AUTOEXTEND ON
/

pause

CLEAR SCR
-- Now, create the RMAN user with it's password, PASSWORD, and
-- its default RMAN_TABLESPACE with unlimited quota space allocation.

-- Then grant the CONNECT, RECOVERY_CATALOG_OWNER, and
-- SYSDBA privileges to the RMAN user.

pause

CREATE USER rman IDENTIFIED BY password
DEFAULT TABLESPACE rman_tablespace
QUOTA UNLIMITED ON rman_tablespace
/

GRANT CONNECT, RECOVERY_CATALOG_OWNER, SYSDBA TO rman
/

pause

CLEAR SCR
-- Now, go to DOS and run rman, and then
-- connect to rman as the rman user

--\/-- DOS> rman RCVCAT rman/password@dbs4rman 

pause
pause

-- Once there, create the Recovery Catalog Repository.
--\/-- rman> CREATE CATALOG;
pause
pause

-- Exit from the Recovery Manager.
-- rman> exit;
pause
pause

CLEAR SCR 
-- Check all off the packages that were created by the
-- CREATE CATALOG command.

pause

SELECT object_name FROM dba_objects
WHERE owner = 'RMAN'
and object_type = 'PACKAGE'
/

-- Now, we are ready to use Recovery Manager (RMAN).

-- Note that:
-- The DBMS_RCVCAT package is responsible for maintaining information 
-- in the recovery catalog.

-- The DBMS_RCVMAN package is used for querying the recovery catalog
-- or the control file.

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