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 with Microsoft SQL Server, users can create application-aware backups and restore up to table level…
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 seen or used until the SPOOL OFF command. The spool command is very useful when…
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 DBCA by using the GUI is very straight forward and simple. But if you don’t…
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 if not added refer my last post to set the environment variables Run the below…
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 TMPDIR ORACLE_BASE=/u01/app/oracle/db;export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/home; export ORACLE_HOMEORACLE_SID=vignesh; export ORACLE_SID PATH=$ORACLE_HOME/bin:$PATH;export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64;export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH You…