Re: [Info-Ingres] Ingres and Dell-Equalogic SAN

[Database Administrator]

Hi Marty,

I do something similar except we use HP business copy to create clones on our SAN.

Typical SAN level commands have to run as root so I had to write a wrapper script that
runs as root and calls ckpdb with a modified cktmpl.def file.

The backup is straight forward but for the restore, the WRTD runs a delay/looping script
that causes the follwarddb to 'pause' while I manually restore the database files.

Andre

________________________________

From: info-ingres-bounces@kettleriverconsulting.com [mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of Martin Bowes
Sent: November 3, 2008 10:08 AM
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Ingres and Dell-Equalogic SAN



Hi All,



I'm trying to make Ingres do backup and recoveries on a Dell Equalogic SAN.



It looks like a simple matter of creating and restoring snapshots, by monkeying with the right points of the cktmpl.def.



It seems simple enough to do the backup, but the restore is a tad more entertaining. In particular the Dell Manual states:

Before restoring a volume from a snapshot, be sure to disconnect any iSCSI initiators from the volume. Otherwise, the restored volume may be corrupted when initiators reconnect to it.



My plan on recovery was to get the tape based template commands to do the job. So I'd have to get the WRTD: to do the deed probably via a script to ensure we disconnect the iSCSI, and then do the restore from the snapshot.



Does anyone have an idea on how to do this from a script? Or should I just get the PRTD to echo a message prompting me to do this and not continuing until the RETURN key is hit in the WRTD?



Martin Bowes