September 30 2013

How to restore critical administrative files using onbar (IDS 12.10.xC2 and above) ?

Tagged Under : , , , , , , , , ,

I notice critical files are being backup by onbar since IDS 11.70, and I have confirmed with IBM Informix support that these files are not able to restore with IDS 11.70.

From IDS 12.10.xC2 onwards, critical files are able to be restored if previous onbar backup completed successfully.

Critical files that we mentioned:
– ONCONFIG
– SQLHOSTS
– ixbar.servernum
– oncfg_servername.servernum

To restore critical files in IDS 12.10.xC2 and above, you have 2 options:
(1) Use ‘onbar -r -cf yes’ to restore critical file during cold restore.
(2) Alternatively, you can use ‘onbar -r -cf only’ to extract critical files while Informix server is offline.

September 25 2013

Informix Archecker – point in time restore/recover table (Scenario 1)

Tagged Under : , , ,

I would like to share this feature with all of you – Informix Archecker.
It can be used to restore/recover a missing table from backup.

Note: Informix Archecker is available since IDS 10.00 or higher.

Scenario 1:

– Someone accidentally dropped a table “state” on 2013-09-25 11:04:16.
– You will restore/recover the table “state” point-in-time until 2013-09-25 11:00:13.
– Database = stores_demo Table = state
– You are using onbar with Netbackup for backup/restore.

September 23 2013

su: cannot set user id: Resource temporarily unavailable

Hi there,
I’m getting following error when I use root to “su – oracle” in Linux. Finally, I found the solution as shown below 🙂

# uname -srm
Linux 2.6.18-308.11.1.el5 x86_64

# su – oracle
su: cannot set user id: Resource temporarily unavailable

# ps -eLF | grep “^oracle” | wc -l
2068

Increase value “nproc soft limit” for oracle:
#– /etc/security/limits.conf –#

#oracle soft nproc 2047
oracle soft nproc 4095

# su – oracle
$ whoami
oracle