Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Introduction: – Suddenly we faced the error ‘Open file limit ‘ while login on Linux server and try to run df -h or any other command. Here will see outofmemory and resolve too many open files error. The likely cause of this issue is hitting max “Open file limit“. This error indicates that all available file handles … Read more
Introduction: – Here we are discussing ‘How to create physical standby database using rman backup restore’ in oracle database. We will follow the simple steps to create standby database. Steps to create physical standby database. Step 1:- Connect to primary database and check recovery area. SQL> show parameter db_recovery; NAMETYPEVALUE ———————————— ———– —————————— … Read more
To create directory in oracle we can use ‘create directory‘ statement (CREATE OR REPLACE DIRECTORY <directory_name> AS ‘<operating_system_path>’;). In this article, we will learn how to create directory in oracle. The following statement will create directory oracle database object that points to a directory on the server: How to create directory in oracle. Syntax: – … Read more
In this post we will discuss about Compress RMAN Backup which will help to compress our database backup. There are different rman backup compression levels with Oracle. BASIC, LOW, MEDIUM and HIGH are the four different compression levels. We must have ‘Advanced Compression’ option license to use LOW, MEDIUM and HIGH levels in oracle. When we … Read more
In this article we will discuss about Oracle RMAN Incremental Backup. An Incremental backup is those backup that only backup datafile blocks that have changed since a specified previous backup. You can make incremental backups of whole databases, individual tablespaces or datafiles. The purpose of an incremental backup is to backup only those data blocks … Read more
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
Introduction: – In this post covers ORA-1652: unable to extend temp segment by 128 in tablespace TEMP error. Generally, we are facing this ora error while running sql query or concurrent program in our Instance. How to resolve ORA-1652 unable to extend temp segment. The ORA-01652 error occurs due to failure in allocating … Read more
Introduction: – Before restoration and recovery of PDB (Pluggable database), we need to ensure that valid rman backup available. Here we will cover restore and recover pluggable database. We can restore using restore pluggable database PDBORCL1; Steps to restore and recover pluggable database. We have already discussed the same in another post. Please check here for … Read more
In this article we will discuss the ‘How to delete concurrent program from backend‘. To delete a concurrent program and executable in Oracle Apps (E-Business Suite), you’ll need to follow a series of steps through the application’s user interface. Please note that making changes to Oracle Apps should be done with caution, as it can … Read more
Introduction:- How to fix ORA-19809 limit exceeded for recovery files. | In this article we will discuss ‘how to resolve ORA-19809 and ORA-19804′ error. This has very common issue while doing RMAN backup, we have faced ORA-19809 and ORA-19804 error due to recovery destination full. In this scenario we will have to remove old archivelog (expired or … Read more