Criar banco standby

[Victor ArmbrustMestre]

mpvargas

Sim cara. Tem custo adicional sim. É um recurso do EE licenciado a parte.

Se liga nesse script para atualização manual, usa de “template” pra vc ai… (Esse está escrito em Shell Script usando Bash). Você pode ir alterando ele conforme sua necessidade.
Para aplicar no servidor standby, você pode executar de tempos em tempos o recover database no RMAN, ou ainda montar um outro script com diversos controles.


#!/bin/bash

Procedimento - Envio Archives Site DR .

Data: 09-07-2008

Por: Victor Armbrust

Tivit Terc. de Tecnologia e Servicos S.A.

#

export TEMP=/tmp
export TMPDIR=/tmp
export ORACLE_SID=pback1
export ORACLE_BASE=/u/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH:/usr/bin:/usr/ccs/bin:/usr/local/bin:/bin/ksh
export ORACLE_OWNER=oracle

data=date +%d%m%y%H
LOG=$ORACLE_HOME/scripts/logs/send_archive_dr_$data.log
DH=date +%Y%m%d-%H%M
export BKPDIR=/u01/archives

###############################################################

Fase 1 - Gerar Backup Archive e Identificar Backup Piece.

###############################################################

echo "*****************************************************************" >> $LOG
echo "Fase 1 - Gerar Backup Archive e Identificar Backup Piece. date" >> $LOG
echo "*****************************************************************" >> $LOG

$ORACLE_HOME/bin/rman target / nocatalog msglog ${LOG} append <> $LOG
echo "****Problema Fase 1 - Gerar Backup Archives - returcode $RETVAL" >> $LOG
echo " " >> $LOG
exit 0

fi

echo "*****************************************************************" >> $LOG
echo "Fase 1 - Successfully Completed date " >> $LOG
echo "*****************************************************************" >> $LOG
echo " " >> $LOG

########################################

Fase 2 - Compactar Backup Archive.

########################################

echo "*****************************************************************" >> $LOG
echo "Fase 2 - Compactar Backup Archive. date" >> $LOG
echo "*****************************************************************" >> $LOG
/usr/bin/gzip /u01/archives/bkp_* >> $LOG
RETVAL=$?
if test "$RETVAL" != "0"
then
echo " " >> $LOG
echo "****Problema Fase 2 - Compactar Archives (BackOffice)" >> $LOG
echo " " >> $LOG
exit 0
fi

echo "*****************************************************************" >> $LOG
echo "Fase 2 - Successfully Completed date " >> $LOG
echo "*****************************************************************" >> $LOG
echo " " >> $LOG

###########################################################################

Fase 3 - Transferir Backup e Identificacao Backup Piece para Site DR.

###########################################################################

echo "*****************************************************************" >> $LOG
echo "Fase 3 - Transferir Backup e Identificacao Backup Piece para Site DR. date" >> $LOG
echo "*****************************************************************" >> $LOG
/usr/bin/sudo /bin/su - svc-transfer-arch -c "scp /u01/archives/*.gz 172.18.51.109:/u01/archives/."
RETVAL=$?
if test "$RETVAL" != "0"
then
echo " " >> $LOG
echo "****Problema Fase 3 - Transferencia Backup para Site DR (BackOffice)" >> $LOG
echo " " >> $LOG
exit 0
fi

echo "*****************************************************************" >> $LOG
echo "Fase 3 - Successfully Completed date " >> $LOG
echo "*****************************************************************" >> $LOG
echo " " >> $LOG

#######################################################################

Fase 4 - Move Backup e Identificacao Backup Piece para Historico.

#######################################################################

echo "*****************************************************************" >> $LOG
echo "Fase 4 - Move Backup e Identificacao Backup Piece para Historico. date" >> $LOG
echo "*****************************************************************" >> $LOG

/bin/mv /u01/archives/*.gz /u01/archives/history
RETVAL=$?
if test "$RETVAL" != "0"
then
echo " " >> $LOG
echo "****Problema Fase 4 - Move Backup para Historico (BackOffice)" >> $LOG
echo " " >> $LOG
exit 0
fi

echo "*****************************************************************" >> $LOG
echo "Fase 4 - Successfully Completed date " >> $LOG
echo "*****************************************************************" >> $LOG
echo " " >> $LOG
exit

Abs
Victor