Oninit cdi / Archive
Talk to an expert →

Restore one chunk

Posted in 2008

Summary

mostv asked how to restore a single corrupted chunk from a level 0 archive without restoring everything. Art Kagel and Martin Fuerderer both said a single chunk cannot be restored; the smallest unit is a dbspace, which can be restored if logical logs are backed up. If it is a critical dbspace (root, logical or physical log), do a full cold restore. Solved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management

mostv via DBMonster.com — — source: Usenet: comp.databases.informix

Hello! If I have one chunk corrupted - how I can restore it? I have arhive 0 level and I don't want to restore all. Thanks. -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/informix/200803/1

↪ replying to mostv via DBMonster.com
Art S. Kagel (Oninit) — — source: Usenet: comp.databases.informix

mostv via DBMonster.com wrote: > Hello! If I have one chunk corrupted - how I can restore it? I have arhive 0 > level and I don't want to restore all. Thanks. You cannot restore a single chunk. However, if you also have the logical logs backed up you can restore the single dbspace that contains the damaged chunk. Read the Backup and Restore Guide for details which differ sightly depending on whether you used ontape or onbar to make the archives. Art S. Kagel =========================================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ===========================================================================================

↪ replying to mostv via DBMonster.com
Martin Fuerderer — — source: Usenet: comp.databases.informix

Hi, you cannot restore a single chunk. The smallest unit you can restore by itself is a dbspace. So you have to restore the dbspace to which the corrupted chunk belongs. If it is a critical dbspace, then you better restore everything because it will be a cold restore anyway. Critical dbspaces are the root dbspace or a dbspace containing (part of) the logical logs or the physical log. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland Entwicklung GmbH Chairman of the Supervisory Board: Martin Jetter Board of Management: Herbert Kircher Corporate Seat: Boeblingen, Germany Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294 informix-list-bounces@iiug.org wrote on 18.03.2008 14:13:55: > Hello! If I have one chunk corrupted - how I can restore it? I have arhive 0 > level and I don't want to restore all. Thanks. > > -- > Message posted via DBMonster.com > http://www.dbmonster.com/Uwe/Forums.aspx/informix/200803/1 > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Martin Fuerderer
mostv via DBMonster.com — — source: Usenet: comp.databases.informix

Thanks! -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/informix/200803/1

Glossary