Create Extension First, if the extension is not present, it is created with the following command. [crayon-66439afe251ba912078478/] The functions we will use; [crayon-66439afe251cb319604275/] Example: We …
Read More »SQL Server Service Is Not Starting Due to Tempdb
SQL Server re-creates tempdb on predefined folders each time sql server service starts. In the article “How To Move The Tempdb Database To Another …
Read More »POSTGRESQL DATABASE MONITORING
In this article I will share some monitoring scripts about postgresql. To Check if the Postgresql service is running via OS(linux): [crayon-66439afe25b41509082858/] …
Read More »How To Delete an ASM Diskgroup
There are several methods to delete the disk group from an ASM. It is possible to do this operation with “Enterprise Manager”, asmca and …
Read More »Mysql Incremental Backup using Percona Xtrabackup
Previously i just shared the full backup script. Now we will take incremental backups using last_checkpoints. Basically, what this script will do is that …
Read More »Mysql Database Backup Using Percona Xtrabackup (Automated Bash Script)
Below is the simple script for taking non-blocking Mysql physical backup using percona xtrabackup toolkit. This backup is encrypted using AES256 algorithm. [crayon-66439afe262db652186839/] –extra-lsndir: save …
Read More »How To Encrypt a Column(Like Password) with chkpass On PostgreSQL
We may need to keep passwords in databases for some reason, and we don’t want anyone to see them, including dba. In postgresql there …
Read More »Some Tips About ASM On Solaris
The partition of the disk to be allocated to ASM should not start from the 0th cylinder. You must start at least from the …
Read More »What is Mounted Drive and How to Create It
We use letters like C, D, E when defining disks on “Windows Server”. If the number of our disks increases, we may not be …
Read More »How To Move the Datafiles in Rac Database
HI Guys, We were put in a Situation that we had to Create the New data files for the tablespaces in the RECO diskgroup …
Read More »