Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  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 …

  Below is the simple script for taking non-blocking Mysql physical backup using percona xtrabackup toolkit. This backup is encrypted using AES256 algorithm. [crayon-673f5f831ccc3351712526/]   –extra-lsndir:  save …

  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 …

  The partition of the disk to be allocated to ASM should not start from the 0th cylinder. You must start at least from the …

  We use letters like C, D, E when defining disks on “Windows Server”. If the number of our disks increases, we may not be …

  HI Guys, We were put in a Situation that we had to Create the New data files  for the tablespaces in the RECO diskgroup …

  If the Oracle UNDO table space is corrupted, it may be possible to get the error as follows. ORA-00376: file string cannot be read …

  I explained how to change the disks of a normal database in the article “How To Change The Disk Of Database Files On SQL …

  In MySQL, views are not only query-able but also updatable. It means that you can use the INSERTor UPDATE statement to insert or update rows of the base table through the …

  The generated AWR baselines cause the snapshots to be stored, so you will not be allowed to delete old snapshots. Therefore, it is necessary …