# Determine paths and names of all database files.
echo 'SELECT file_name FROM dba_data_files
      UNION 
      SELECT name FROM v$controlfile
      UNION       
      SELECT member FROM v$logfile;' | sqlplus / as sysdba

# Shut down the instance
echo "SHUTDOWN IMMEDIATE" | sqlplus / as sysdba

# Create a backup directory.
mkdir $ORACLE_BASE/backup
mkdir $ORACLE_BASE/backup/`date '+%Y-%m-%d'`

# Copy the files manually to the backup directory
cd /u01/app/oracle/oradata/o11g
cp * $ORACLE_BASE/backup/`date '+%Y-%m-%d'`

# Startup the instance again.
echo "STARTUP" | sqlplus / as sysdba

