Forum OpenACS Q&A: Re: OT: Backup solutions
Currently I both do an export and an rman hotbackup every night, although some of the larger (data warehouse type stuff) tablespaces I may only export once per week, if the server they're on is old and slow. The export and hotbackup files then go to tape.
I've tweaked those scripts I posted them a year, but they do basically the same thing. The script are also a bit baroque in places (the various options and redirection of output and such), but that seemed useful when I was testing them.