We have EMC CX700. Two LUNs from this storage are assigned to RedHat Linux AS4 server. We are using these two LUNs for Oracle 10g database. This is transactional database, constantly changing, once a transaction is complete it is deleted from this database.
As a backup solution for this database we are planning to setup to create snapshot on these two LUNs every one hour and keep upto 6 snapshots.
I am looking for script to create a snapshot from the host and delete old one. Also I believe it is possible to create this snapshot in consistency mode as these LUNs are used for database, we need snapshot of these two LUNs in consistency mode.
Or if you can provide any other method to automate this process that will be helpful.
Flarecode is version 19.x
We are using Brocade switch in this SAN configuration. All ports are open, we did not configure zoning on these switch.