Re:Backup Strategy - Informal Survey

2002-09-20 Thread dgoulet
Robert, I don't do exports of our large production systems mainly due to the fact that I'd have to export them to tape and getting that much quite time, so as not to bump in to an ORA-01555 or have someone else hit a rollback segment issue, is impossible. Consequently two hot backups a week

Re:Backup Strategy - Informal Survey

2002-09-20 Thread Gene Sais
Robert - My info: Oracle 8.1.7 E.E. Largest DB is 900gb Hot Backups 2x week Cold Backups 1x month Export Backups 1x week on selective schemas I do export backups for creation of test db's, recover data validation blunders, i.e. single object restores. Future plans are RMAN, RMAN, RMAN on 9i.