I need to know about backup & recovery strategies for partitioned Database in Sybase ASE 15.7 . I am not worried about transaction failure & recovery scenarios
We have already faced this 2 scenarios previously in un-partitioned database & it took more than 6 hrs for us to recover back [Reason : Low level sybase error]
In case of catastrophic failure like,
- Data corruption (Some low level defect causes a table corruption that went unnoticed for days or weeks)
- Failure of a device [A storage system gets corrupted]
Is my idea good to partition my database to achieve better resiliency?
In case I am doing so, is it possible to recover only failed partition? Sybase ASE maintains logical partitions, so is it possible to do piecemeal recovery?
In case my primary partition gets corrupted because of sybase low level error / disk corruption, will my replica also gets corrupted? [After all it's a replication :)]