RMAN Installation and Configuration

1. Install 10.2.0.3 Oracle Home and create starter Database (ORACLE_SID – XXXX, Port Pool - 0)

2. Create tablespace for RMAN Catalog:

CREATE TABLESPACE RMAN_CATALOG
DATAFILE '/usr/oraXXXX/XXXXdb/db/oradata/XXXX/RMAN_CATALOG.DBF'
SIZE 10240K AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
LOGGING
ONLINE
SEGMENT SPACE MANAGEMENT AUTO;

3. Create RMAN User:

CREATE USER RMAN IDENTIFIED BY rman
DEFAULT TABLESPACE RMAN_CATALOG
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;

GRANT "CONNECT" TO RMAN;

GRANT "RESOURCE" TO RMAN;

GRANT "DBA" TO RMAN;

GRANT RECOVERY_CATALOG_OWNER TO RMAN;

GRANT UNLIMITED TABLESPACE TO RMAN;

4. Create RMAN Catalog:

$ rman catalog=rman/rman
RMAN> create catalog tablespace rman_catalog

5. Add following tns entry to TARGET tnsnames.ora:

XXXX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = host.domain) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XXXX)
)
)

6. Test RMAN connection from TARGET server and register database:

$ $ORACLE_HOME/bin/rman target=sys/manager@TARGET catalog=rman/rman@XXXX
rman> register database;

7. Run a test backup:

$ $ORACLE_HOME/bin/rman target=sys/manager@TARGET catalog=rman/rman@XXXX
rman> run {
backup database include current controlfile;
backup archivelog all delete input;
}