Can I recover a damaged Online 5.02?
Posted in 2000
Topics: Installation, Setup & Upgrades, Logging & Checkpoints
Hi, In the past days, I tried to alter a table in a database with unbuffered logging due to the high number of rows in the table, all the logical logs become full and Informix shutdown abnormally, now I can't put the Informix in online mode, and I don't have neither a bakup or archive (I was using the /dev/null for backup logical logs). There is a way to recover all the data contained in the data base? My installation is Informix Online 5.02, SCO Open Server 5.02 Thanks. Manuel Ortiz
In article <8fhopt$c5m$1@news.xmission.com>, Ortiz Manuel <mortiz@gtireecu.com> writes > >Hi, > >In the past days, I tried to alter a table in a database with unbuffered >logging due to the high number of rows in the table, all the logical logs >become full and Informix shutdown abnormally, now I can´t put the Informix >in online mode, and I don´t have neither a bakup or archive (I was using >the /dev/null for backup logical logs). There is a way to recover all the >data contained in the data base? > >My installation is Informix Online 5.02, SCO Open Server 5.02 > Talk to Informix Technical Support. They may be able to patch the server. ie truncate the logical log and leave you with an inconsistent database. >Thanks. >Manuel Ortiz -- David Williams