MongoDB is a cross-platform, document oriented database that provides, high performance, high availability, and easy scalability. MongoDB works on concept of collection and document. Database Database is a physical container for collections. Each database gets its own set of files…
Everyone is aware that whether you are using on-premise or public cloud you need backup of your Virtual Machines or cloud instances. You can read more about the types of backup here This script creates the application consistent snapshot of…
Recently i posted on Installing MariaDB on AWS EC2 instance and securing the installation. After securing the installation, the root user login is failing with error Access denied for user ‘root’@’localhost’ (using password: YES) The problem is the root user…
Recently I have posted on installing MySQL in Amazon Linux, Now I am trying to Integrate and test Maria Backup and Recovery integration. In our product we support the Backup and recovery of MySQL instance in EC2, you can read…
One of our POC customers has few Oracle databases running in their datacenter, they wanted to create application-consistent backups of their Virtual machines running Oracle server using Nimesa. Read more about What is application consistent backup Nimesa has tight integration…
The SPOOL is a command causes SQLPlus to write the results to a file on the operating system. Once spool is set, SQLPlus will continue to spool the output until the command SPOOL OFF. Note that the file cannot be…
Day 2 activity of the DBA’s, after setting up the database server and configured all the required privileges and applying the patch, we will create a new database Developers and SysAdmins also should know to create database. Creating database from…
An Oracle database can run in one of two modes. By default, the database is created in NOARCHIVELOG mode. This command will check to see if you have altered your database to run in ARCHIVELOG mode. Set the environment variables…
After the successful installation of oracle, need to set some environment variables to access clients like SQLPLUS, setup the TMPDIR, ORACLE_BASE, ORACLE_HOME and add the lib to path Change the Base location, and SID as per your environment TMPDIR=$TMP; export…
The data is moving to the cloud, many enterprises are moving to the cloud in full swing. Instead of refactoring the whole set of application companies start their cloud journey with Lift and shift and few organisations are using multi-cloud.…
