Hi Shiva,
thanks, appreciate your input.
It is little compliated, having as many volume as databases is not an option here for other reasons. Its an HPUX running Progress databases for various applicatons. They have their own backup system to take backup to tape. So, once they these databases are quiesced and snapshoted, they are mounted at specific time on another backup host as filesystems and back up to tape. Another requirement was to - snapshot all together, not in a separate script. I had done this with single database with single script from snapcreator framework, but to get all of them together was an issue. I had thought about the volume restore concern (restoring all together), but then snapshot backups works fine,. If the the point in time recovery is immediate, then flexclone works pretty well, they can choose a previous snapshot and create a volclone and mount that database at the 'original mount point' and they are up. Apart from this, they also do 'redo' log shipping to the remote standby database for any DR situation. As I said, it is little complicated, but I am open to discussion, ideas.
Any thoughts ?
Thanks,
-Ashwin