MigraTI - Soluções em banco de dados

Guob 2017

terça-feira, 15 de março de 2011

Criar Catalogo do Rman

Passo a Passo para criar um catalogo do Rman em sua base de dados.
Muito útil para gerenciar varias bases de dados em um único ponto.

###############################
# Criar Tablespace do Rman #
###############################
create tablespace rman datafile '+DGDADOS/tksup/rman01.dbf' size 100M AUTOEXTEND ON NEXT 20M MAXSIZE 2000M force logging;


#######################
# Criar owner #
#######################

create user rman identified by rman default tablespace RMAN temporary tablespace temp quota unlimited on RMAN;

#######################
# Grants #
#######################

grant recovery_catalog_owner to rman;
grant connect, resource to rman;


#######################
# criação do catalogo #
#######################

rman catalog rman/rman

create catalog;


########################
# Registrar database #
########################

rman catalog=rman/rman target=rman/rman
register database;

Nenhum comentário:

Postar um comentário