Oracle redundancy setup

 0 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
markv
New Member
Posts: 1
New Member
    We run LSF 9 with oracle 10.1 on HPUX. The entire oracle binaries/database is in one filesystem which is mirrored between two sans at different locations. We suffered a data loss last week when the inode table to this filesystem became corrupted due to a possible bug in the HPUX online jfs code. It affected our data files and our archive logs so we were only able to roll forward a few hours from our last backup.

    To prevent this we are planning to multiplex our archive logs and online redo logs to a pair of local high speed disks in a HFS filesystem and make the paths optional. Periodically a binary copy of the control file will be written to the disks also.

    My questions are:
    1) What are some of the other customers using for oracle redundancy? Is anyone else multiplexing arcs/redo logs to another filesystem on another set of disks?

    2)What is the benefit of "Backup control file to trace"? Whether I have a trace file or the binary version I still have to recover using "with backup control file until cancel"? Plus with trace I have to run the sql script. I can't just copy it over the restored control files.

    Thanks
    Mark Meriter hospital