oracle
-
Application consistent backup of Oracle database
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…
-
How to dump Oracle sqlplus output to a file
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…
-
Create Oracle database from command line
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…
-
How to check if the ORACLE database is in archive log mode
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…
-
Environment variables to set for Oracle server – Post Installation
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…