imported restore with ISM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mweallans@panacea.co.uk - 29 Nov 2005 16:56 GMT

I am having difficulty with imported restore with ISM

I set the environment variables and run the ism_catalog command. It
never completes. I've left it for as much as 30 minutes and nothing is
happening.

sddev1:D::/home/informix>export ISM_CLIENT=north
sddev1:D::/home/informix>export ISM_SERVER=sddev1
sddev1:D::/home/informix>export ISM_DATA_VOLUME_POOL=ISMData
sddev1:D::/home/informix>export ISM_LOG_VOLUME_POOL=ISMLogs
sddev1:D::/home/informix>ism_catalog -recreate_from /ISMData/nDBlevel0
scanner: scanning file disk nth0511182200DD on /ISMData/nDBlevel0
scanner: file disk nth0511182200DD already exists in the media index
scanner: no client resource found for host `loopback',
no index entries to be saved for save set
`INFORMIX:/onlineipc_nr/rootdbs/0' (ss
id 60620)

Does anybody have any ideas on what might be wrong?

regards

Malcolm

Reply to this Message

Neil Truby - 29 Nov 2005 21:50 GMT

>I am having difficulty with imported restore with ISM
>
[quoted text clipped - 19 lines]
>
> Malcolm

Don't tell him! They stole our client!

Reply to this Message

Martin Fuerderer - 30 Nov 2005 10:12 GMT

Hi,

are you sure you need to run "ism_catalog -recreate_from ..." command ?
The manual says to run this in the following situations:
- Recovering expired save sets
- Recovering volumes that are eligible for recycling
- Recovering volumes that have been deleted from the ISM catalog

But in the following situations (the second being your scenario ?)
- The ISM catalog is corrupted
- You reinstalled the operating system and the Informix database
server software, which includes the ISM software
I think you should run the command "ism_catalog -recover". For
this you must first have the correct volume located (using your
"Bootstrap Printout") and mounted. If you do not have the
"Bootstrap Printout", then I think you first have to run the command
"ism_catalog -find_bootstrap <device>" ...

See manual "IBM Informix Storage Manager Administrator's Guide",
especially chapter 5, section "Recovering Data After a Disaster".

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

owner-informix-list@iiug.org wrote on 29.11.2005 17:56:33:

> I am having difficulty with imported restore with ISM
>
[quoted text clipped - 19 lines]
>
> Malcolm

sending to informix-list

Reply to this Message