Crear Catálogo de Recuperación RMAN

Pasos sencillos para crear el area de información o catalogo de respaldos para el Recovery Manager de Oracle


######Configurar Catalogo RMAN

###Habilitar Modo Archive en Base de Datos de Catalogo
SQL> shutdown immediate ;

SQL> STARTUP MOUNT EXCLUSIVE;

SQL> ALTER DATABASE ARCHIVELOG;

SQL> ARCHIVE LOG START;

SQL> ALTER DATABASE OPEN;

#Crear Tablespace para almacenar información del catálogo
SQL> CREATE TABLESPACE tscatalog DATAFILE '+DATA/tscatalog.DBF' SIZE 300M autoextend on

#Crear usuario para acceder al catalogo rman
SQL> create user rman identified by rman;

SQL> alter user rman default tablespace tscatalog temporary tablespace temp;

SQL> alter user rman quota unlimited on tscatalog;

#Asignar permisos a usuario rman
SQL> grant connect, resource, recovery_catalog_owner to rman;

=========================================================================
###Crear la estructura de información del catalogo rman
RMAN> connect target/ ;

RMAN> connect catalog rman/rman;

RMAN> create catalog tablespace tscatalog;

RMAN> register database;

RMAN> configure default device type to disk;

RMAN> configure retention policy to recovery window of 7 days;