Basic of RMAN Backup and Recovery Scenario

Backup and recovery is a common task in DBA’s Daily Routine. Let’s have looked over the process to take backup of Oracle database and know about the process to recover the database. Check the archive log status

Create a dummy table for testing

Take a Backup

Insert more rows and Shutdown the […]

Read More

RMAN Time Based Recovery

RMAN is the most useful tool for Oracle in DBA’s life. Today’s post is about “RMAN Time Based Recovery”. Let’s have look on the steps. First, take the full backup.

Create a table

Now drop the table

start the database in mount state

set the NLS parameter and run the RMAN […]

Read More

Advantage Of RMAN in Oracle

This post is for those who are new in “Oracle RDBMS”, Being a part of Oracle technology in Database. “RMAN” plays an important part in “Backup&Recovery”. “RMAN” has its own benefits. Let’s have looked over the “RMAN” benefits.     RMAN helps to DBA have incremental where only modified data blocks will be copied It integrity checks for the […]

Read More

TNS-12547: TNS:lost contact

Being DBA we all are aware that we must have knowledge of OS level too because Database not just runs over the only one OS. In a different organization, we have a different OS. Being a part if IT we understand that different OS environment has a different parameter. We have to set them. Today […]

Read More

ORA-12154: TNS:could not resolve the connect identifier

We are continuing with the same series of listener errors. Let’s have looked over the new error. Let’s go for the steps

Condition for error When Database is on in restricted on no mount status and you will see service handler for this instance is on BLOCKED or RESTRICTED state.

Solution: Add (UR=A) […]

Read More

ORA-12516:TNS protocol stack in Oracle

Let’s start the series of Oracle listener. Now are going to focus over the issue for the following errors. Let’s have looked over the steps and solve the issues.

Cause: None of the known and available service handlers for the given SERVICE_NAME support the client’s protocol stack: transport, session, and presentation protocols. Solution: check […]

Read More

ORA-12505: TNS:listener in Oracle

Being human being we have a lot of unlimited qualities. Listening is one of them. Normally we ignore it but it is most important for all. Good listing keeps us away from 99% problems away and life makes us simple but if we don’t listen properly we invite unlimited problem in our life. In same […]

Read More

How to Purge Listener Log in Oracle

Being DBA we all are aware that Oracle Database makes a connection with a client with the help of listener. Oracle provides the facility to have look over the status of Oracle listen. Being a part of IT we must be aware that 24*7 We require database live but due to some unfortunate conditions database […]

Read More

ORA-12162: TNS:net service name is incorrectly specified

Let’s have look on some listener issues in the database. Cause: The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified. Action: If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If […]

Read More

MAXDATAFILES and other files in Oracle

This Post is about the trick by which we can use to monitor the CRDs of Oracle Database. Monitoring is the most important and common task in RDBMS. Without monitoring CDR Let’s have look on the query which we use to monitor main elements of Oracle Database CDRs. — MAXDATAFILES Select ‘MAXDATAFILES ‘ || records_total […]

Read More