We are helping people to find the right jobs. Please click the advertisements on this page to serve you better.
Saturday, March 30, 2013
Thursday, March 28, 2013
Wednesday, March 27, 2013
Tuesday, March 26, 2013
Monday, March 25, 2013
Saturday, March 23, 2013
Friday, March 22, 2013
Tuesday, March 19, 2013
Medical Faculty posts by Himachal Pradesh (HP) Public Service Commission (PSC)
Himachal Pradesh Public Service Commission (HPPSC) Recruits the
post(s) of Professors and Assistant Professors, Class-I (Gazetted) in
various disciplines in the Department of Medical Education :
How to Apply : Apply Online at HPPSC website upto 16/04/2013. Print out of the system generated registration form should be send on or before 01/05/2013.
Please view further details at http://hp.gov.in/hppsc/file.axd?file=2013%2f3%2fAdvt.+VII.pdf and for online submission of application, syllabus, details etc., please visit the website http://www.hp.gov.in/hppsc/ and please see left sidebar
- Assistant Professor : 23 posts in various Medical Disciplines in Department of Medical Education, HP, Pay Scale : Rs. 37400 - 67000 AGP Rs. 8900/-, Age : 45 years.
- Professor : 03 posts in various Medical Disciplines in Department of Medical Education (Dental) (HPGMDC, Shimla), Pay Scale : Rs. 37400 - 67000 AGP Rs. 10000/-, Age : 45 years.
- Assistant Professor (Prosthodontics) : 01 post, Pay Scale : Rs. 37400 - 67000 AGP Rs. 8900/-, Age : 45 years.
- Assistant Professor (Orthodontics) : 01 post, Pay Scale : Rs. 37400 - 67000 AGP Rs. 8900/-, Age : 45 years.
Application Fee
: Application on the specimen form duly completed should be accompanied
by examination fee of Rs. 250/- (Rs.63/- for candidates belonging to
SC, ST and OBC categories of Himachal Pradesh only), through a challan
by cash in the branches of Punjab National Bank.
How to Apply : Apply Online at HPPSC website upto 16/04/2013. Print out of the system generated registration form should be send on or before 01/05/2013.
Please view further details at http://hp.gov.in/hppsc/file.axd?file=2013%2f3%2fAdvt.+VII.pdf and for online submission of application, syllabus, details etc., please visit the website http://www.hp.gov.in/hppsc/ and please see left sidebar
Monday, March 18, 2013
Sunday, March 17, 2013
Saturday, March 16, 2013
Thursday, March 14, 2013
Wednesday, March 13, 2013
Tuesday, March 12, 2013
Monday, March 11, 2013
Friday, March 8, 2013
Thursday, March 7, 2013
Tuesday, March 5, 2013
Order Food Online India
Daily the number of people using online applications / internet have been increasing in India. But when it comes to order food online with a payment gateway, only a few are there
Monday, March 4, 2013
Sunday, March 3, 2013
Saturday, March 2, 2013
Max DB Replication Scripts
Max DB Replication Configuration for Standby modules
Scripts for automating standby Max Db
Shipping of the redo log backups
Once the standby instances data area contains a complete data backup of the primary instance, the standby instance can be updated by recovering log backups of the primary instance.
This is only possible if all redo log backups that had been created after the initial data backup had been done are applied in the order the backups where created.
If any log is missing in the sequence no further logs can be applied to the standby instance.
We need to ship log backups from Primary Maxdb Server - prodmaxdb server to DR server - stdmaxdb to the location lc_backup.
Secondly we need to ensure that log files which are shipped should have permission 666 and owner of the files should be sdb:sdba and slpadm has the permission to delete the same after applying.
Script
At user home location save the scripts : restore.txt and restore_script.sh
It only restores 1 log backup on each run.
Restore.txt has the commands that the dbmcli should execute once inside the dbmcli.
Contents of restore.txt
db_admin
db_connect
recover_start LOG_BACKUP LOG 1060
db_admin
db_connect
recover_replace LOG_BACKUP /lc_backup/LOG_BACKUP_060110 1061
recover_cancel
The restore_script.sh has the logic for changing restore.txt before executing it.
#!/bin/bash
IND=`ls /lc_backup/LOG_BACKUP_060110* | cut -d. -f2 | sort -r | tail +2 | sort -r`
for i in $IND; do
ANT=`echo $i - 1 | bc`
POS=`echo $i + 1 | bc`
sed '/recover_start/s/'$ANT'/'$i'/g' /home/slpadm/restore.txt | sed '/recover_replace/s/'$i'/'$POS'/g' > /tmp/restore.$i.tmp
DIF=`diff /home/slpadm/restore.txt /tmp/restore.$i.tmp | wc -l`
if [[ $DIF == 0 ]] ; then
echo "Error"
else
cp /tmp/restore.$i.tmp /home/slpadm/restore.txt
chown sdb:sdba /lc_backup/*
chmod 666 /lc_backup/*
dbmcli -n [Primary Maxdb Server IP] -d SLP -u control,welcome -c -i /home/slpadm/restore.txt
if [[ $? == 0 ]] ; then
rm /lc_backup/LOG_BACKUP_060110.$i
rm /tmp/restore.$i.tmp
else
echo "Error"
exit 1
fi
fi
done
exit 0
Monitoring
We can check whether log file is applied or not by checking the output of the script located at /home/slpadm – MaxdbRestore.log
recover_start LOG_BACKUP LOG 1060
OK
Returncode -8020
Date 20100820
Time 00100652
Server prodmaxdb
Database SLP
Kernel Version Kernel 7.6.04 Build 009-123-182-193
Pages Transferred 42688
Pages Left 0
Volumes 1
Medianame LOG_BACKUP
Location /lc_backup/LOG_BACKUP_060110.1060
Errortext
Label LOG_000001060
Is Consistent
First LOG Page 43679963
Last LOG Page 43722628
DB Stamp 1 Date 20100814
DB Stamp 1 Time 00095734
DB Stamp 2 Date 20100816
DB Stamp 2 Time 00010840
Page Count 42666
Devices Used 1
Database ID prodmaxdb:DBID
Max Used Data Page
Converter Page Count
Also you can check the status of the database in Windows – Database Manager.
Scripts for automating standby Max Db
Shipping of the redo log backups
Once the standby instances data area contains a complete data backup of the primary instance, the standby instance can be updated by recovering log backups of the primary instance.
This is only possible if all redo log backups that had been created after the initial data backup had been done are applied in the order the backups where created.
If any log is missing in the sequence no further logs can be applied to the standby instance.
We need to ship log backups from Primary Maxdb Server - prodmaxdb server to DR server - stdmaxdb to the location lc_backup.
Secondly we need to ensure that log files which are shipped should have permission 666 and owner of the files should be sdb:sdba and slpadm has the permission to delete the same after applying.
Script
At user home location save the scripts : restore.txt and restore_script.sh
It only restores 1 log backup on each run.
Restore.txt has the commands that the dbmcli should execute once inside the dbmcli.
Contents of restore.txt
db_admin
db_connect
recover_start LOG_BACKUP LOG 1060
db_admin
db_connect
recover_replace LOG_BACKUP /lc_backup/LOG_BACKUP_060110 1061
recover_cancel
The restore_script.sh has the logic for changing restore.txt before executing it.
#!/bin/bash
IND=`ls /lc_backup/LOG_BACKUP_060110* | cut -d. -f2 | sort -r | tail +2 | sort -r`
for i in $IND; do
ANT=`echo $i - 1 | bc`
POS=`echo $i + 1 | bc`
sed '/recover_start/s/'$ANT'/'$i'/g' /home/slpadm/restore.txt | sed '/recover_replace/s/'$i'/'$POS'/g' > /tmp/restore.$i.tmp
DIF=`diff /home/slpadm/restore.txt /tmp/restore.$i.tmp | wc -l`
if [[ $DIF == 0 ]] ; then
echo "Error"
else
cp /tmp/restore.$i.tmp /home/slpadm/restore.txt
chown sdb:sdba /lc_backup/*
chmod 666 /lc_backup/*
dbmcli -n [Primary Maxdb Server IP] -d SLP -u control,welcome -c -i /home/slpadm/restore.txt
if [[ $? == 0 ]] ; then
rm /lc_backup/LOG_BACKUP_060110.$i
rm /tmp/restore.$i.tmp
else
echo "Error"
exit 1
fi
fi
done
exit 0
Monitoring
We can check whether log file is applied or not by checking the output of the script located at /home/slpadm – MaxdbRestore.log
recover_start LOG_BACKUP LOG 1060
OK
Returncode -8020
Date 20100820
Time 00100652
Server prodmaxdb
Database SLP
Kernel Version Kernel 7.6.04 Build 009-123-182-193
Pages Transferred 42688
Pages Left 0
Volumes 1
Medianame LOG_BACKUP
Location /lc_backup/LOG_BACKUP_060110.1060
Errortext
Label LOG_000001060
Is Consistent
First LOG Page 43679963
Last LOG Page 43722628
DB Stamp 1 Date 20100814
DB Stamp 1 Time 00095734
DB Stamp 2 Date 20100816
DB Stamp 2 Time 00010840
Page Count 42666
Devices Used 1
Database ID prodmaxdb:DBID
Max Used Data Page
Converter Page Count
Also you can check the status of the database in Windows – Database Manager.