RMAN (How to Check/Validate That RMAN Backups Are Good)

From today’s post, I am going to remind you all about those colleges day when we used to learn about the validation in programming languages. In daily life are aware of validation. In the database world, it is little different. Let’s have look at the types of validation in general terms. Some of the types […]

Read More

Errors:- (ORA-01450: maximum key length (3215) exceeded)

Today we are going to have look on the topic of the Rebuilding index. In this post we are going to learn why do we need rebuilding the index? It explains the steps we use to solve the error. While we rebuild the index we face the problem. 06:19:09 [SYS][TEST]>> ALTER index PRS.UK_F_HEADER rebuild online; ALTER index […]

Read More

Performance Tuning(How to find database growth on a Monthly wise)

Today we are going to have look at the Database growth. With the help of the given query. DBA can find the monthly growth of there database. Sometimes little information is too much useful. select to_char(CREATION_TIME,’RRRR’) year, to_char(CREATION_TIME,’MM’) month, round(sum(bytes)/1024/1024/1024) GB from   v$datafile group by  to_char(CREATION_TIME,’RRRR’),   to_char(CREATION_TIME,’MM’) order by   1, 2; YEAR MO              GB —- […]

Read More

Backup&Recovery(RMAN restore problem)

I took rman backup from RAC server to restore to another (new) RAC server.   This post is about some issues occurs face in RAC environment during the restore. RMAN> restore database; Starting restore at 09-OCT-15 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1.1 channel ORA_DISK_1.1: sid=108 instance=prod1 devtype=DISK allocated channel: ORA_DISK_2.1 channel ORA_DISK_2.1: sid=107 […]

Read More

Safe Harbor Statement – Oracle

Safe Harbor Statement All the posts are intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and […]

Read More

Oracle Database 18c and it’s features

Finally, Oracle officially released Oracle Database 18c with Oracle Documentation available on Oracle Public Cloud(OPC).  To get more detailed on Oracle 18c release read Oracle Support Document 2285040.1. List of some new features in Oracle 18c: Data Guard Oracle Data Guard Multi-Instance Redo Apply Supports Use of Block Change Tracking Files for RMAN Backups Automatic Correction […]

Read More

TopicWise Interview Question on Oracle Database

Here is some Oracle Listeners Interview Question, hope it will help you. Listener Question: http://clouddba.co/generic-dba/ Here is some Oracle Tablespace  Interview Question, hope it will help you. Tablespace Question: http://clouddba.co/generic-dba/ Here is some Oracle EXPDP IMPDP Datapump Interview Question, hope it will help you. EXPDP IMPDP Datapump Question: http://clouddba.co/expdp-impdp-datapump-interview-questions/ Here is some Oracle Database Architecture Interview Question, hope it will help you. Database Architecture Question: http://clouddba.co/database-architecture-interview-questions/ […]

Read More

LOCAL=NO & LOCAL=YES in Oracle

LOCAL = NO: non-local connection, namely a network connection. Listener connect to the server. Client application through the client listener listener sends a request to the server, the server listens received in connection with the database, perform related operations, the results returned to the client. This is the process by listening. So you need to […]

Read More

Oracle Database Maximum Availability Certified Expert

Hi Readers Finally I’ve successfully achieved  Oracle Database Maximum Availability Certified Expert. It was almost more than 6 months that I’ve been preparing for this. To achieve this certification, we must complete ALL the three certifications: Oracle Database 12c Administrator Certified Professional Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administration Oracle Certified Expert, Oracle Database […]

Read More

Difference between .bashrc and .bash_profile

Difference Between .bashrc and .bash_profile : We use .bashrc and .bash_profile frequently to set environment for Oracle. Here is the difference between both files ,which file is used when . location of .bashrc : /home/username/.bashrc location of .bash_profile : /home/oracle/.bash_profile .bashrc : This file is executed for non-login shells . .bash_profile : This file is executed […]

Read More