V7 hot backup script for unix

From: Ron Beery <rbeery_at_wtcp.DaytonOH.NCR.COM>
Date: 17 Jan 94 15:47:47 GMT
Message-ID: <2580_at_wtcp.DaytonOH.NCR.COM>

I've put together the following for V7 Hot backups in unix. What is the concensus of the Net? Am I missing something? Have I covered all the bases?

How can I automate the check of the results of hotback.sql to be sure it ran without error?

hotback.sh

---

cd $db_dir                       # The top database directory
mv hotback.log hotback.log.old
rm save/db/*                     # Ensure the save directory is clear

$ORACLE_HOME/bin/sqldba lmode=y <<EOF
_at_hotback.sql
exit
EOF
#now backup to tape

hotback.sql

---

SPOOL hotback.log
SET ECHO ON CONNECT INTERNAL REM * Taken from Allan Edwards, Oracle Procedings, Online backups, Paper 37 ALTER SYSTEM CHECKPOINT;
REM * ALTER TABLESPACE SYSTEM BEGIN BACKUP;
!cp db/testsys01.dbf save/db
!cp db/testsys02.dbf save/db

ALTER TABLESPACE SYSTEM END BACKUP; ALTER TABLESPACE RBS BEGIN BACKUP;
!cp db/testrbs.dbf save/db

ALTER TABLESPACE RBS END BACKUP; <Repeat for the other tablespaces>

ALTER SYSTEM SWITCH LOGFILE; REM * Get the redo logs
!cp db/testlog1a.rdo save/db
!cp db/testlog2a.rdo save/db
!cp db/testlog3a.rdo save/db

REM * Move the archived logs
!mv arch/* save/arch

ALTER DATABASE BACKUP CONTROLFILE TO 'save/db/testcntrl.bak'; ALTER DATABASE BACKUP CONTROLFILE TO TRACE NORESETLOGS;

-- 
"Everything is computerized.  What could possibly go wrong?"
Ron.Beery_at_wtcp.DaytonOH.NCR.COM  

Received on Mon Jan 17 1994 - 16:47:47 CET