I tested my hot backup script yesterday. It is almost done. I need to alter the syntax slightly so it does ‘archive log current’ instead of ‘alter system switch logfile’. Making the redo log “current” purges all current activity from the redo logs and writes it to a permanenet .arc log file. I must capture that last bit of activity to fully recover the datafiles after the hot copy. Once this script is working and in Production I am going to work through my Oracle Wait Interface book one chapter at a time. The hotbackup stuff is something every DBA should be able to do. The wait-interface stuff is slightly more esoteric but excellent for diagnosing performance problems.