The concept of a “Recycle Bin” plays a crucial role in data recovery and management. This feature, introduced in Oracle 10g, is akin to the recycle bin in Windows or the trash in macOS, providing a safety net for data that has been deleted. In this article, we will discuss the recycle bin in Oracle, …
How to check recycle bin in Oracle: Purge, enable/disable Read More »
In this article, we will check about the various ways Oracle database can be shut down, what things happen during shutdown, How to shutdown the RAC Database Oracle Shutdown steps decoded We can shut down the Oracle database in four ways(i) Shutdown normal(ii) Shutdown immediate(iii)Shutdown abort(iv) Shutdown Transactional sqlplus / as sysdbashutdown Normalsqlplus / as …
R12.2 is the latest Release of Oracle E-business Suite Products. Here we will be discussing the Login flow in R12.2 and how to troubleshoot login issues in R12.2 Login flow in R12.2 Here is the processing in terms of URL(Login HTTP headers) When the EBS login works OK, the browser will be redirected to various …
As part of learning the Oracle SQL tutorial, Here is good detail on the group by Oracle Group by Oracle We use Group by in the select statement to group rows into summary rows using column or expression. We often used aggregate or group functions on the group to obtain the summary rows Syntax SELECT col1, …
Archive logs keep accumulating and we need to put things in place to delete them on a regular basis. We should not be deleting the archivelog from the filesystem directly as the Oracle Database is not aware of that and space is not released in the Flash recovery area Let’s see a few commands on …
Types of Corruption in Oracle There are two types of corruption. a. Physical corruption: This happens generally due to media corruption. In this case, the block does have an invalid checksum. It may contain zero. This is generally the result of infrastructure issues like media, network, and memory. RMAN block recovery can be used to …
How to check block corruption in Oracle database and Fix it Read More »
