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

  pt-online-schema-change is a binary part of Percona-toolkit packages by Percona. It’s one of the most stable and efficient, tools for performing large MySQL table structure change in …

  Do the operating systems kill your MySQL instances from time to time? Are some database servers swapping constantly? These are relatively common problems. Why? …

  12c R1 Has a New Feature to suppress the generation of redo during Data Pump import. This feature not only suppresses the redo generation …

  NoSQL databases are highly scalable and flexible database management systems which allow you to store and process unstructured as well as semi-structured data which …

Note: First try below steps on test or non-prod server. Keep software ready and accessible. root access required to install binaries. create new mount point …

Error: During RMAN backup, you can see the following errors. ORA-00245: control file backup operation failed RMAN-08132: WARNING: can not update recovery area reclaimable file …

  Introduction MySQL, the most popular Open Source SQL database management system developed, distributed, and supported by Oracle Corporation. In this article we’ll go over …

Error: When connecting to RMAN, it generates output when any command is given, but the command is not completed and is waiting. Reason: Disruption in …

  In some cases, there may not be enough space on the disks where the database files are located. For this reason, you may need …

Error: When we try to create a file in NFS mounted directory we get an error like this and we can not create the file …