Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Oracle Database Administration is basically for Database administration for Every DBA.
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
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
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: – 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
In this article we will discuss how to move datafile online in oracle. We know that Oracle introduced moving datafiles online in 12c to minimize the downtime. Prior to oracle 12c, required taking datafile offline and copy it at OS level and bring it back online again. Oracle 12c includes an enhancement to ALTER DATABASE … Read more
Introduction:- In this article we will discuss about Data Pump Enhancements in Oracle Database. NOLOGGING Option (DISABLE_ARCHIVE_LOGGING)The TRANSFORM parameter of impdp has been extended. Data pump enhancements:- NOLOGGING Option (DISABLE_ARCHIVE_LOGGING) The TRANSFORM parameter of impdp has been extended to include a DISABLE_ARCHIVE_LOGGING option. The default setting of “N” has no any effect on logging behavior. Using a value “Y” reduces the … Read more
Enable auto extend |Before enabling the auto extend datafile size in oracle database. Make sure free space available on disk. Some time we need to enable auto increment for datafile to extend its size while data growing up frequently. How to Enable auto extend. First of all, we have to … Read more
Introduction:- Here will cover how to fix collect2 ld returned 1 exit status. Below error occurs during relink while applying the patch in oracle database. See how to Issue the failed relink command: How resolve collect2 ld returned 1 exit status. Error:- collect2: ld returned 1 exit statusmake[1]: *** [/data02/1124home/sysman/lib/libnmemso.so] Error 1make: *** [libnmemso] Error … Read more
In this post we will cover ORA-48223 Interrupt Requested Fetch Aborted Return Code [12751] [HM_FINDING]. Error:- ORA-48223 Interrupt Requested Fetch Aborted Return Code [12751] [HM_FINDING] | Errors in file /data01/ORAHOME/log/diag/rdbms/ace/PROD/trace/PROD_m000_7649.trc: ORA-51106: check failed to complete due to an error. See error below. Fixing ORA-48223 Interrupt Requested Fetch Aborted à If anyone facing … Read more
Here we will discussed environment and tasks of an Oracle Database administrator (DBA). It also discusses DBA security and how you obtain the necessary administrative privileges. Administering an Oracle Database:- A small site can have one database administrator who administers the database for application developers and users related issues. Database Administrator:- Database requires … Read more