Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Showing results for 
Search instead for 
Did you mean: 

Informix Database Recovery

Occasional Visitor

Informix Database Recovery

I have done a warm restore of a particular database using the "ontape" command eg. "ontape -r -D dts_dbs" without restoring the archive logs.

After recovering, I am still unable to access the database. When I do a onstat -d , I notice the flag is showing the chunk as "PI-" , it showing the database is inconsistent.

Appreciate if there is anyone that could help me as I need to bring up the database urgently.


Ricky B. Nino
Frequent Advisor

Re: Informix Database Recovery

Hi Jason,

INFORMIX warm restore involves 2 required steps. Physical and Logical Restores. Meaning, you MUST perform both before the dbspace will be brought on-line and available for use.

The Physical Restore consists of restoring pages from level-0 up to level-n archive of a given DB.

While, Logical Restore uses logs backed up after the level-n archive.

Before you begin the restore, it is strongly recommended that you back up the logical logs so that the logical restore will read all necessary transactions from tape.

Warm restores are NOT possible if you do not back up the logical logs.

hope this help...
Opportunities expand for people willing to put time and effort into learning new skills.