OraMatt: YABAOracle

Here’s little script to help copy a file out of ASM..enjoy

——————————————————————————

#/bin/bash -x 

# Query to find file_names 
# select file_name from dba_data_files;

export ORACLE_SID=+ASM
export ORACLE_HOME=/u01/app/oracle/grid #ASM home
export TIMESTAMP=`date +%m%d%y%H%M`
export DBNAME=orcl
export DISKGROUP=data
export DATAFILE=matt_ts.269.806502489
export OUTFILE=matt_ts

# Copy datafiles via asmcmd

asmcmd <<EOF
cp ${DISKGROUP}/${DBNAME}/DATAFILE/${DATAFILE} /tmp/${OUTFILE}.${TIMESTAMP}
exit
EOF

ls -ahtl /tmp/${OUTFILE}.${TIMESTAMP}