–###################################################################### –# Autor : Rodrigo Mufalani (rodrigo@mufalani.com.br) –# Data : Fev 25, 2012 –# De : Mufalani –# Para : –# Motivo : Gerar comandos set newname for datafile para todos os datafiles de um database –###################################################################### –# Obs : Alterar os paths OLD e NEW –###################################################################### set trimspool on set pages 0 set lin[…]
############################################################################################ #!/bin/ksh # Author : Rodrigo Mufalani – rodrigo@mufalani.com.br # Date : July 11th, 2009 # From : # To : # Purpose : Backup of production database with Recovery Manager to store on /some/hotbackup ############################################################################################ # Obs.: This script was build on 9i R2 database but still can be use on new releases ############################################################################################set[…]
###################################################################### #!/bin/bash # Author : Rodrigo Mufalani (rodrigo@mufalani.com.br) # Date : November 19th, 2009 # From : Mufalani # To : # Purpose : Archive *.trc data monthly ###################################################################### # Obs : Remember to set your env variables accordingly ###################################################################### set -a ORACLE_BASE=/u01/app ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0 PATH=/usr/bin:/usr/ccs/bin:/usr/ucb:/usr/sbin:/usr/local/bin:/etc:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:. NLS_LANG=’american_america.WE8ISO8859P1′ DBA=’suporte@mufalani.com.br’ HOST=`hostname` DATA=`date +%d%m%y_%H%M` DUMPDIR=/tmp OUTF=${DUMPDIR}/log_traces_${HOST}_${DATA}.out ERRF=${DUMPDIR}/log_traces_${HOST}_${DATA}.err set +a[…]
–###################################################################### –# Autor : Rodrigo Mufalani (rodrigo@mufalani.com.br) –# Data : Fev 24th, 2012 –# De : Mufalani –# Para : –# Motivo : Verificar locks no banco –###################################################################### –# Obs : Peguei pronto e ajustei –###################################################################### set pagesize 85 col username format a10 col osuser format a15 col sid format 9999 col serial format 99999[…]
–###################################################################### –# Autor : Rodrigo Mufalani (rodrigo@mufalani.com.br) –# Data : May 24h, 2010 –# De : Mufalani –# Para : –# Motivo : Ajustar retenção de undo e tbs de undo –###################################################################### –# Obs : –###################################################################### set serverout on declare qry_dem number; und_ren number; spc_req number; und_reo number; und_tbs varchar2(30); und_siz1 number; und_siz2 number; und_siz3[…]
Olá amigos, Nosso 1º encontro Guob 2012 está chegando, em 24/03/12. Esse ano, estamos iniciando nossas atividades em março e teremos um bom ano para os apaixonados por tecnologia. Contamos com a ilustre presença de Craig A. Shallahamer (Orapub.com) Craig é um pesquisador, escritor e professor de milhares de profissionais Oracle. Seu foco é Oracle performance management, o que levou a publicar mais de 24 trabalhos técnicos e autoria do livros Oracle[…]
Temos uma parceria com a Mufalani IT Services desde 2009 para suporte e administração da nossa plataforma Oracle e também para serviços especificos de DBA em nossos clientes. Sabemos que podemos sempre contar com a Mufalani IT Services (especialmente para suporte emergencial imprevisto, não é pessoal ?). A Mufalani IT Services tornou-se mais do que[…]
Olá pessoal, Vou inaugurar o novo blog com um post que eu achei interessante de uma demanda que um cliente passou essa semana. Com a ferramenta SQL Developer e uma dúzia de clicks é possível converter a estrututra de uma base de dados MySQL inteira para um banco de dados Oracle. Há no site da[…]