Backup and Restore in a DMZ

From: Holger Marzen <holger_at_marzen.de>
Date: 28 Feb 2002 20:00:46 GMT
Message-ID: <a5m29e$q04$1@bluebell.marzen.de>

I have an Oracle 8.0.5 that has to be backed up.

No big problem, but the machine is located in a DMZ - I cannot have connections to other db servers or fancy clicky flashy enterprisy tools.

Controlfiles and the rest of the operation system is backed up daily. I use rman without a repository and save the whole db (backup database), switch log and archive the logs (db is in log archive mode).

As I have read I cannot do a timestamp recovery with that data. Is that true? Can I do a complete recovery including the last database backup and roll forward with all the available logs?

Another question:
Would it be possible to mirror the online logs via NFS on another machine, so I'd even could roll forward the data with the remaining log if the db machine completely blows up and has to be replaced and reinstalled? Received on Thu Feb 28 2002 - 14:00:46 CST