CODEWITHSUNDEEP
databaseinformixdatabase-backups
Starc
Starc

Reputation: 117

How to backup a single database residing in a dbspace in Informix?

I would like to backup a single database residing in a dbspace , while backup utilities in Informix such as onbar or ontape would provide whole system ,logs ,dbspaces backup only .Is there any way to do single database backup in Informix ? if there is then please tell me how to backup and restore a single database ?

Upvotes: 1

Views: 618

Answers (3)

jacques
jacques

Reputation: 240

you can use the multitenancy feature if you are running an ids12.10 version. There's a special flag -T to restore a database with onbar in a multitenancy environment.

Upvotes: 0

Pradeep Natarajan
Pradeep Natarajan

Reputation: 370

Simply put, Informix does not have a database level backup and restore option. As you mentioned, onbar and ontape allow you to do backups and restore for the entire Informix instance. Having said that, if you are interested in having redundancy for a single database (residing in a dbspace) you can achieve it by turning on mirroring for that dbspace.

Upvotes: 0

Mislav
Mislav

Reputation: 31

If you need backup you could put database in its own dbspace. Then use "warm restore" only for that dbspace.

If you want to migrate database from instance to instance you can use dbexport/dbimport or onunload/onload but be careful and read the manuals first. There are some drawbacks connected with both utilities.

Upvotes: 2

Related Questions