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

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