PRCD 1119 failed to create database while using dbca.

Introduction: – PRCD 1119 failed to create database DEVDEB because the database unique name matches that of database DEVDEB in the first 8 characters. Identify error. While trying to create CDB using dbca, recently we faced error PRCD-1119. Here will cover how to resolve it. As we can see, the error is clearly visible in … Read more

How to fix ORA-12547 TNS lost contact

Introduction:- In this article, we are going to resolve ORA-12547 TNS lost lost contact error.   Error:- ORA-12547: TNS:lost contact $ sqlplus / as sysdba SQL*Plus: Release Production on Thu Mar 25 09:38:40 2021 Copyright (c) 1982, 2013, Oracle.  All rights reserved. ERROR: ORA-12547: TNS:ost contact   Above error can occur for many reason. In … Read more

How to resolve ORA 39213 metadata processing is not available

Introduction:- In this article we will learn how to resolve the ORA 39213 metadata processing is not available error while trying to export the table in oracle using dataPump utility. Using Datapump utility we can export/import any database objects in oracle. While doing the facing error ORA 39213 metadata processing. Exporting table using DataPump. $expdp … Read more

How to compress full incremental backup L0, L1 backup using rman

Introduction:- Basically Backup compress full incremental backup is the feature of Oracle Database which offer more benefit. We can take the oracle rman backup as normal or in compress mode. Restoration process of compressed backup will same as uncompressed backup. Compress Full Incremental backup using RMAN:-  Incremental backups can be either level 0 or level … Read more

How to Recompile invalid objects in oracle

In this article, we will cover how to recompile invalid objects in oracle database. If Oracle objects package, procedure, function, trigger and views become invalid when dependent object has changed.  How to find invalid objects in oracle Check how many invalid objects in oracle database. SQL>select owner,object_name,status,object_type from dba_objects where status=’INVALID’; SQL>select object_name,status from dba_objects where … Read more

RMAN Backup and Recovery Interview Questions

Introduction: – RMAN Backup And Recovery Interview Questions| Here is useful RMAN Backup and Recovery Interview Questions/Answers for DBA. Below are oracle rman interview questions. Q⟹ What is RMAN?   A⟹RMAN is an Oracle Database client that performs backup, restoration,recovery and administrative tasks in oracle Database. It greatly simplifies the dba jobs by managing the production … Read more

Container Database CDB and Pluggable database PDB Backup and Recovery.

Introduction: –   As we know that Oracle introduced multitenant Container Database CDB and Pluggable database PDB Backup and Recovery in 12c. Using RMAN client we can perform the backup of entire Container Database (CDB) or individual Pluggable Database (PDB) and also perform the point-in- time recovery.     Before starting the RMAN backup, we should … Read more