August 21 2014
Informix Archecker – point in time restore/recover table (Scenario 2)
Tagged Under : archecker, Informix, netbackup, onbar, point in time
I would like to share this feature with all of you – Informix Archecker.
It can be used to restore/recover (point-in-time) to a new target table (new table name) from backup.
Scenario 2:
– Someone accidentally performed a mass update for all rows in table “customer” on 2014-08-21 10:48:00.
– You need to restore & recover (point in time) to a new table called “customer_res” until 2014-08-21 10:46:00. (Current table “customer” will be maintained)
– Database = stores_demo, Source Table = customer, Target New Table = customer_res
– You are using Informix Archecker with Netbackup Informix Agent for backup/restore.
Note: Informix Archecker is available since IDS 10.00 or higher.
(1) 2014-08-21 09:50:00:
$ dbaccess stores_demo –
> select count(*) from customer ;
(count(*))
28