A user accidentally truncated tables all located in a single dbspace
of a database, but I'm unable to restore the individual dbspace as a
warm onbar restore -- onbar log grouses "Storage space <dbspace> is
not down so it will not be restored." However, I've been able
to restore single non-critical dbspaces with down chunk statuses using
onbar before. So how do I change the status of a non-mirrored chunk
in the dbspace to 'down' to force the restore?

If you have a list of the tables, you may want to consider using archecker to perform a table level restore to the time right before your user truncated them.

-----Original Message-----
From: informix-list-bounces (AT) iiug (DOT) org [mailto:informix-list-bounces (AT) iiug (DOT) org] On Behalf Of red_valsen
Sent: Tuesday, June 28, 2011 3:25 PM
To: informix-list (AT) iiug (DOT) org
Subject: Dbspace restore

A user accidentally truncated tables all located in a single dbspace of a database, but I'm unable to restore the individual dbspace as a warm onbar restore -- onbar log grouses "Storage space <dbspace> is
not down so it will not be restored." However, I've been able
to restore single non-critical dbspaces with down chunk statuses using onbar before. So how do I change the status of a non-mirrored chunk in the dbspace to 'down' to force the restore?
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

Overwrite the first chunk of the dbspace with garbage. Then query something
that resides in that chunk. The server will mark it down.

HOWEVER, the easier fix is to use archecker to extract the deleted data rows
from the archive and reinsert them back to the table(s).

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Tue, Jun 28, 2011 at 4:24 PM, red_valsen <red_valsen (AT) yahoo (DOT) com> wrote: