Pular para o conteúdo principal

Backup Rápido e simples com RMAN

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/b01/backup/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/b01/backup/%d_DB_%u_%s_%p';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/db10g/dbs/snapcf_control.f';

--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;}

--Incremental - Todos os blocos alterados desde o mais recente backup 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;}





-- Cumulativo - Todos os blocos usados desde o mais recente backup FULL.

{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;}





-- Exemplo de schedule do backup usando CRONTAB

crontab -l

#############################################################
# BACKUP POR RMAN #
#############################################################
0 02 * * sat "/b01/scripts/./bckinc1_r1.sh"
0 02 * * sun "/b01/scripts/./bckinc0_r1.sh"
0 02 * * mon "/b01/scripts/./bckinc1_r1.sh"
0 02 * * tue "/b01/scripts/./bckinc1_r1.sh"
0 02 * * wed "/b01/scripts/./bckinc1c_r1.sh"
0 02 * * thu "/b01/scripts/./bckinc1_r1.sh"
0 02 * * fri "/b01/scripts/./bckinc1_r1.sh"


-- Script

denilson@localhost:~> cat "/b01/scripts/./bckinc0_r1.sh"
#####################################
# Script backup rman #
# 06-10-2008 #
# editado: denilson #
# #
#####################################

export ORACLE_HOME=/u01/app/oracle/product/db10g;
export PATH=$PATH:$ORACLE_HOME/bin;
export ORACLE_SID=orcl;
log=`echo $ORACLE_SID`_FULL_`date +%Y_%m_%d_rman.log`
$ORACLE_HOME/bin/rman target / @/b01/scripts/bckinc0_r0.sql >> /b01/logs/orcl/banco/logs/$log 2>> /b01/logs/orcl/banco/logs/$log

Comentários

Postar um comentário

Postagens mais visitadas deste blog

Index SKIP SCAN???

Index Skip Scan nada mais é que o "split" logico de um indice composto, ou seja, se sua clausula WHERE não tiver todos os campos do indice composto, ele é dividido em menores sub-indices Exemplo: -------- SQL> create table teste(a number,b number); Table created. SQL> begin 2 for i in 1..1000 3 loop 4 insert into teste values(i, 56); 5 end loop; 6 end; 7 / PL/SQL procedure successfully completed. SQL> create index idx_teste on teste(a,b); Index created. SQL> analyze table teste compute statistics; Table analyzed. SQL> explain plan for select /*+ index_ss(teste idx_teste) */ * from teste where b=56; Explained. SQL> start ?\rdbms\admin\utlxpls.sql -------------------------------------------------------------------------------- | Operation | Name | Rows | Bytes| Cost | Pstart| Pstop | -------------------------------------------------------------------------------- | SELECT STATEMENT | | 1
Postar um comentário
Leia mais

Webcenter Content - Jython to Checkin Content with Attachments (CHECKIN_NEW_WITH_RENDITIONS)

In the last few days, i had to load a content that, by its requirements, needs to attach files to the content. My first alternative would be Batch Loading, however for the bacth loder file it was not possible because it does not actually support the rendition service. With the next option, i tried to use the IdcCommand, but still had many problems, such as errors below: sample hda file: [oracle @ hostname bin] $ cat idctst.txt @Properties LocalData IdcService = EDIT_RENDITIONS dID = 37020 renditionKeys = addRendition0 addRendition0.name = test543 addRendition0.action = edit addRendition0.file = test.txt addRendition0.file: path = / u01 / oracle / domains / content_domain / ucm / cs / vault / ~ temp / test.txt @end << EOD >> Executing: [oracle @ hostname bin] $ ./IdcCommand -f idctst.txt -u sysadmin -l log.log -c server Error: Java HotSpot (TM) 64-Bit Server VM warning: Using the ParNew young collector with the Serial old collector is deprecated and w
Postar um comentário
Leia mais

Configurar Tamanho de UNDO e tempo de RETENÇÃO (UNDO_RETENTION)

-- Tamanho Undo Atual SELECT SUM(a.bytes) "UNDO_SIZE" FROM v$datafile a, v$tablespace b, dba_tablespaces c WHERE c.contents = 'UNDO' AND c.status = 'ONLINE' AND b.name = c.tablespace_name AND a.ts# = b.ts#; -- Blocos de UNDO por Seg. SELECT MAX(undoblks/((end_time-begin_time)*3600*24)) "UNDO_BLOCK_PER_SEC" FROM v$undostat; --Tamanho do Bloco SELECT TO_NUMBER(value) "DB_BLOCK_SIZE [KByte]" FROM v$parameter WHERE name = 'db_block_size'; -- Select calcula UNDO RETENTION SELECT d.undo_size/(1024*1024) "ACTUAL UNDO SIZE [MByte]", SUBSTR(e.value,1,25) "UNDO RETENTION [Sec]", ROUND((d.undo_size / (to_number(f.value) * g.undo_block_per_sec))) "OPTIMAL UNDO RETENTION [Sec]" FROM ( SELECT SUM(a.bytes) undo_size FROM v$datafile a, v$tablespace b, dba_tablespaces c WHERE c.contents = 'UNDO'
2 comentários
Leia mais