Restaurar Banco de Dados
Boa tarde
Estou meio perdido sem saber ao certo por onde começar, e gostaria que alguém me ajudasse com algumas dicas;
tenho esse script:
####################
# Variaveis Oracle #
####################
export ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=WINT
export ORACLE_LIB=$ORACLE_HOME/lib
export LIBPATH=$ORACLE_HOME/lib:/usr/dt/lib
export PATH=$PATH:$ORACLE_HOME/bin
#########################
# Variaveis de Ambiente #
#########################
DATA=`date +%d%m%Y`
HORA=`date +%H%M%S`
SID="WINT"
DBA_USER="exportar/exprt24erh"
EXP_DIR="/db/backup"
EXP_PAR="BACKUP"
EXP_FILE="exp_db_$DATA-$HORA.dmp"
EXP_LOG="exp_db_$DATA-$HORA.log"
EXP_OPTS=" full=y exclude=statistics directory=$EXP_PAR dumpfile=$EXP_FILE logfile=$EXP_LOG"
LOGCOMP="compress_`date +%d-%m-%Y-%H%M%S`.log"
############
#Limpa Log #
############
cd /db/backup/checklist/
rm -f compress*.log exp*.log
find /db/backup/backup_old -name "*.tar.z" -mtime +30 -exec rm -f {} \;
#################
# Inicia Export #
#################
expdp $DBA_USER $EXP_OPTS
######################
# Inicia Compactacao #
######################
cd /db/backup
cp -v *.log /db/backup/checklist/export_`date +%d-%m-%Y-%H%M%S`.log
echo -e "\n Compression Start Backup " >> $LOGCOMP
if tar -zcvf backup_db_$DATA-$HORA.tar.z *.dmp e*.log >> $LOGCOMP
then
du -hs backup_db_$DATA-$HORA.tar.z >> $LOGCOMP
echo -e "\n Compression successfully " >> $LOGCOMP
cp compre*.log checklist/
else
echo -e "\n Compression unsuccessfully " >> $LOGCOMP
cp compre*.log checklist/
fi
rm -f *.dmp *.log
Bom, montei uma maquina Windows com o mesmo banco 12c, e agora, queria saber como eu faço para restaurar esse banco no Windows?, pegando tudo?
grato
Joerbeth

Discussão (1)
Carregando comentários...