Could you suggest the best backup & recovery strategy for a 1-2 TB Oracle 8i DB.
Is it advisable to use offline or RMAN backup & recovery.
Would it be advisable to have backup done weekly.
How long does it take for a DB of that size.
Is it advisable to take snapshots and any third party products that you can suggest for backup and recovery.
Oh GOD! 1-2 Terabytes of OLTP environment. Probably you have work from different aspects specific to your environment. I don't know what kinda hardware configurations are in place for this kinda environment. How big is going to your redologs and whats the frequency of redolog generation. this much more important if you want have standby and limit your MTTR.
To be honest with you, I can't think of Managing 1-2 Terabytes of OLTP without perfect hardware configuration and tools. Whats the version of database ? OS ? Think of Shareplex/Logical standby too... as failover mechanism. Any specific reason for not going Clustered Environment ??