Oracle Database Discussions

I'm looking for a user-managed hot backup script for 11gR2 on Unix. My client does not want to use RMAN.

I think the basic steps are:

- alter system switch logfile
- alter system log archive current
- alter database begin backup
- alter database backup controlfile ( and also backup to trace)
- copy datafiles, redo, archives, controlfiles to somewhere else
- take database out of hotbackup mode
- I also capture spfile and some other config files

Recovery is just restoring to original locations, STARTUP, and end backup.

Crucially, there may be cases where we have archives that were made after the hotbackup that we want to apply. In that case, it's RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL in order to apply the archives.

Sound right?