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 The following is 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 timing […]

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

ORA-08104: This Index Object Is Being Online Built Or Rebuilt

This post is about “ORA-08104”.  We are going t learn how to solve this issue. Steps are mention below:- While dropping an index, if you are facing ORA-08104 error, then you need to clean it using dbms_repair Problem: SQL> drop index eric_icmsprod.SOTRAN00_IDX1; drop index eric_icmsprod.SOTRAN00_IDX1 * ERROR at line 1: ORA-08104: this index object 94771 […]

Read More

Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials

Hi Readers Finally I’ve successfully passed 1Z0-337,  Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials. It was almost more than 2 months that I’ve been preparing for this. The Exam contains 60 questions related to Compute, Container, Networking and Ravello Services. To earn this certification you need to get 70% marks. This was the result of […]

Read More