Pular para o conteúdo principal

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



Comentários

Postar um comentário

Postagens mais visitadas deste blog

Webcenter Content - Cache Configuration for JdbcFileStore configuration

The configuration values below, control the temporarily cached files keep in FileCache table. FsCacheThreshold Specifies the maximum cache size, in megabytes (default=100) Once the threshold is met, Content Server starts deleting files that are older than the minimum age, as specified by the FsMinimumFileCacheAge parameter FsMaximumFileCacheAge The age at which files are deleted, expressed in days. The default is 365 days FsMinimumFileCacheAge The minimum age at which cached files can be deleted This parameter is used in conjunction with the FsCacheThreshold parameter to determine when to delete cached files FsCleanUpCacheDuringIndexing This parameter activates vault cache cleaning, while FsCacheThreshold, FsMaximumFileCacheAge and FsMinimumFileCacheAge are controling its behaviour.  Expect, when this is enabled on a system that currently has a large number of files in the FileCache table, the first cycle will take a long time to complete. How to Confi...
Postar um comentário
Leia mais

Assign Backup Policy for Boot and Block Volumes - OCI

To get Availability Domain oci iam availability-domain list  #!/bin/bash OCI_AD="hQsi:SA-SAOPAULO-1-AD-1" OCI_COMPARTMENT="ocid1.compartment.oc1..aaaaaaaavgyjpoffz5qliieawamjaksfb6juxejurtduclqjkvv66ookcxja" #Get Silver policy ocid funct_get_policy(){ OCI_POL_OCID=$(oci bv volume-backup-policy list | jq -r '.data[] | select(."display-name"|contains("silver"))' | jq -r '.id') } funct_boot_vol (){ #Create a file with all boot volume ocid oci bv boot-volume list --availability-domain ${OCI_AD} -c  ${OCI_COMPARTMENT} | jq -r '.data[].id' > boot-vol.txt while IFS="" read -r p || [ -n "$p" ] do   printf 'Seeting backup policy for %s\n' "$p"   oci bv volume-backup-policy-assignment create  --asset-id  $p  --policy-id ${OCI_POL_OCID} done < boot-vol.txt } funct_block_vol (){ #Create a file with all block volume ocid oci bv volume list  -c ${OCI_COMPARTMENT} | jq -r '.data[].id' ...
Postar um comentário
Leia mais

Logical Backup Using dbms_datapump

Sample scripts to make a logical backup using dbms_datapump -- BACKUP BY SCHEMA declare h1 NUMBER; begin h1 := dbms_datapump.open (operation => 'EXPORT', job_mode => 'SCHEMA', job_name => 'TESTE2', version => 'COMPATIBLE'); dbms_datapump.set_parallel(handle => h1, degree => 1); dbms_datapump.add_file(handle => h1, filename => 'BKP_SCHEMAS.LOG', directory => 'BKP_DATA_PUMP', filetype => 3); dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0); dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''DENILSON'')'); dbms_datapump.add_file(handle => h1, filename => 'BKP_SCHEMAS.DMP', directory => 'BKP_DATA_PUMP', filetype => 1); dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1); dbms_datapump.set_parameter(handle => h1, name ...
Postar um comentário
Leia mais