Criando Catalogo RMAN

1 - Criando Usuário Banco do Catálogo

CREATE TABLESPACE "TBSRMAN"

DATAFILE '/u02/oradata/orcl/TBSRMAN01.DBF' SIZE 100M

AUTOEXTEND ON NEXT 10M MAXSIZE 2000M

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

CREATE USER RMAN IDENTIFIED BY RMAN

TEMPORARY TABLESPACE TEMP

DEFAULT TABLESPACE TBSRMAN

QUOTA UNLIMITED ON TEMP;

GRANT CONNECT, RESOURCE, RECOVERY_CATALOG_OWNER TO RMAN;

2 - Criando Catálogo

[oracle@denilson ~]$ rman target / catalog rman/rman@dbrman

RMAN> CREATE CATALOG;

recovery catalog created

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

É possivel agora armazenar os scripts de backup:

RMAN> create global script CUMULATIVO
{backup as compressed backupset incremental level 1 cumulative database plus
archivelog delete input;
crosscheck archivelog all;
crosscheck backupset;
delete noprompt obsolete;
delete expired archivelog all;
delete expired backupset;}

RMAN> create global script INCREMENTAL
{backup as compressed backupset incremental level 1 database plus archivelog
delete input;
crosscheck archivelog all; crosscheck backupset;
delete noprompt obsolete;
delete expired archivelog all;
delete expired backupset;}

RMAN> create global script FULL
{backup as compressed backupset incremental level 0 database plus archivelog
delete input;
crosscheck archivelog all;
crosscheck backupset;
delete noprompt obsolete;
delete expired archivelog all;
delete expired backupset;}

-- Executando script armazenado:

RMAN > run {execute script FULL;}

Você pode consultar mais informções no artigo abaixo:

http://dicasoracledba.blogspot.com/2009/05/backup-rapido-e-simples-com-rman.html