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

Recompile JSP EBS - R12.2

1. Backup $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/ $ mv _pages _pages_old 2. Stop services cd $ADMIN_SCCRIPTS_HOME ./adapcctl.sh stop ./admanagedsrvctl.sh stop oafm_server1 ./admanagedsrvctl.sh stop oacore_server1 3. Compile the jsps manually  cd $FND_TOP/patch/115/bin/ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p             4. Checking $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages $ ls -ltr  5. Start services cd $ADMIN_SCCRIPTS_HOME ./admanagedsrvctl.sh start oacore_server1 ./admanagedsrvctl.sh start oafm_server1 ./adapcctl.sh start 6. Clear your web browser cache
Postar um comentário
Leia mais

How to Disable WebLogic Server Diagnostic Framework (WLDF)

[weblogic@yourhost ]$ cd $MW_HOME/oracle_common/common/bin/ [weblogic@yourhost bin]$ ./wlst.sh Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands wls:/offline> connect('weblogic','password','t3://host_ip:port') Connecting to t3://xx.xx.xx.xx:7001 with userid weblogic ... Successfully connected to Admin Server "AdminServer" that belongs to domain "WeblogicDomain". Warning: An insecure protocol was used to connect to the server. To ensure on-the-wire security, the SSL port or Admin port should be used instead. wls:/WeblogiDomain/serverConfig/> edit() Location changed to edit tree. This is a writable tree with DomainMBean as the root. To make changes you will need to start an edit session via startEdit(). For more help, use help('edit'). wls:/WeblogiDomain/edit/> startEdit() Starting an edit session ... Started edit session, be sure...
Postar um comentário
Leia mais

Oracle Data Modeler and SQL Developer: change user interface (GUI) language

Oracle Data Modeler and Oracle SQL Developer does not allow to change the user interface language in “Options” or somewhere else in the GUI. This applies to the versions: Oracle SQL Developer Data Modeler - Version All and later (18.2.0 in my case) Oracle SQL Developer - Version 3.2 and later However, it’s possible switch to other language, changing datamodeler\ide\bin\ide.conf configuration file. The following lines should be added to the file for support English: AddVMOption -Duser.language=en AddVMOption -Duser.country=US Restart application! SQL Developer and Data Modeler supports the following languages: French(fr), German(de), Italian(it), Spanish(es), Brazilian Portuguese(pt BR), Japanese(ja), Korean(ko), Simplified Chinese(zh CN), Traditional Chinese(zh TW).
Postar um comentário
Leia mais