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: – 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
Resolving Shutdown Immediate Hang Situations | Sometimes we are facing the situation were shutting down the instance with shutdown immediate seems to take infinite time and database look like that the session is hung. In most of the cases this is not a hang. Hang can be defined as a scenario when few sessions/processes are … Read more