image

How to know number of databases installed in my oracle and how to know how many databases are up??

How to know the number of databases installed inĀ  my Oracle ?? Solution: check corntab entry i.e. check oratab file /etc/oratab or We can know it from ORACLE_HOME/dbs location there we can find out how many databases are there in that conected perticular server.We can know it from Pfile & Spfile.If we create the database … continue reading

image

Backup Types in Oracle

Backing-up is a crucial process that everyone should do in order to have a fail-safe, for when the inevitable happens. The principle is to make copies of particular data in order to use those copies for restoring the information if a failure occurrs (a data loss event due to deletion, corruption, theft, viruses etc.). You … continue reading

image

DROP a Database using RMAN Oracle

How to Drop a Database using RMAN in ORACLE: Use the drop database command to drop a database from the RMAN prompt. Here are the steps to follow: 1. Start up the database in mount exclusive mode: SQL> startup mount exclusive; Database mounted. SQL> exit 2. From the RMAN interface, use the following command to … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube