August 21 2014

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

Tagged Under : , , , ,

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

July 08 2014

Undefined subroutine &main::read_file called at crspatch.pm line 86. while running ./rootcrs.pl

Tagged Under : , , ,

I got below error when I ran “./rootcrs.pl –patch” as a last command

[root@Server1 ~]# cd /usr/grid_app/oracle/product/11.2/grid/crs/install
[root@Server1 install]# ./rootcrs.pl -patch
Using configuration parameter file: ./crsconfig_params
Undefined subroutine &main::read_file called at crspatch.pm line 86.

Followed roothas.pl -patch or rootcrs.pl -patch Fails with ‘Undefined subroutine’ (Doc ID 1268390.1)

2] Take a backup of the file /crs/install/crsconfig_lib.pm

# cd /crs/install
# cp crsconfig_lib.pm crsconfig_lib.pm.bak

Make the following change in that file crsconfig_lib.pm

From
my @exp_func = qw(check_CRSConfig validate_olrconfig validateOCR
To
my @exp_func = qw(check_CRSConfig validate_olrconfig validateOCR read_file

Now try with
roothas.pl -patch
or
rootcrs.pl -patch

July 08 2014

HAIP is up on some nodes but not on all RAC nodes

Tagged Under : , ,

[racserver1:oracle] /usr/oracle $ crsctl stat res -t -init
——————————————————————————–
NAME TARGET STATE SERVER STATE_DETAILS
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.asm
1 ONLINE ONLINE racserver1 Started
ora.cluster_interconnect.haip
1 ONLINE OFFLINE
ora.crf
1 ONLINE ONLINE racserver1
ora.crsd
1 ONLINE ONLINE racserver1
ora.cssd
1 ONLINE ONLINE racserver1
ora.cssdmonitor
1 ONLINE ONLINE racserver1
ora.ctssd
1 ONLINE ONLINE racserver1 OBSERVER
ora.diskmon
1 ONLINE ONLINE racserver1
ora.drivers.acfs
1 ONLINE ONLINE racserver1
ora.evmd
1 ONLINE ONLINE racserver1
ora.gipcd
1 ONLINE ONLINE racserver1
ora.gpnpd
1 ONLINE ONLINE racserver1
ora.mdnsd
1 ONLINE ONLINE racserver1