asrblogger A symlink is a symbolic Linux/ UNIX is a special kind of file that points to another file on your machine/server, or a connected file system. It similar to a shortcut in WindowsOS. Unlike a hard link, a symbolic link does not contain the data in the target file. It simply points to another entry … Read more
To start a physical standby database, follow these steps using SQL*Plus with administrator privileges: Start the database in NOMOUNT mode: Mount the standby database: Start managed recovery (optional): Start the DB with SRVCTL commands– SYNTAX FOR START DBsrvctl start database -d db_name [-o start_options] where start_option is nomount/mount/open(default)e.gsrvctl start database -d CERTDB -o nomountsrvctl start … Read more
Primary Get standby redo log info: Monitor lag in standby including RAC Monitor recovery progress in standby DB Hope it helped !! 
Hey Folks !! With the enhancement in Oracle 23ai features one of the beautiful thing which we can see is to get a descriptive error messages which was not present in earlier Oracle release version. Use ERROR_MESSAGE_DETAILS to control whether the database raises an additional stacked error message, with further details about the data values encountering the … Read more
Hey Folks !! Oracle Database 23c, the latest long-term support release, brings over 300 new features, with a focus on three key areas:1. AI for Data2. Dev for Data3. Mission-Critical for Data For the past couple of years, DBA & developers have been accustomed to writing SELECT … FROM DUAL to obtain the result of … Read more
Hey Folks !! In Oracle patching, the terms prepatch and postpatch refer to specific sets of tasks or procedures that need to be performed before and after applying a patch to an Oracle database or software environment. prepatch.sh is executed once each ORACLE_HOME, but there are two different scripts, one for the CRS_HOME and the … Read more
Each wait event in Oracle belongs to a specific class. Below is a breakdown of the various wait classes and their descriptions: 1. Administrative These waits occur due to DBA commands that cause users to wait, such as during an index rebuild. 2. Application Waits caused by user application code, like lock waits due to … Read more
Size of the Data: Determine the size of the database objects you intend to export. This includes tables, indexes, and other database structures. Compression: Decide whether you’ll use compression during the export process. Compressed exports require less disk space but may take longer to complete. Export Options: Consider any additional options you’ll use during the … Read more
Hey Folks !! Today I have received a client requirement regarding exporting few columns from a table in Oracle 19c. Here are three methods you can use to achieve this:1. Use Create Table As Select (CTAS) to directly create a table with the specific columns you need.2. Utilize the Export and Import functionality, and then … Read more
Hey Folks !! Today I will guide you towards the process of raising Oracle SR via metalink website or also known as My Oracle Support. There are several reasons why we may need to connect with Oracle Support: Typically, Oracle DBAs are tasked with raising a Technical Service Request (SR), whether it’s for an ongoing … Read more