Running Oracle Database on Amazon Web Services (AWS) Relational Database Service (RDS) provides a variety of advantages, including scalability, flexibility, and managed services. However, in order to secure your sensitive…
Read MoreOracle Database 23c, Oracle Corporation’s most recent release, includes a slew of new features and changes designed to provide organizations with expanded capabilities and improved performance. Overview: Enhanced machine learning…
Read MoreTo use SQL Server, you need a login. You can log in using a regular Windows account or a special SQL Server account. SQL Server Supports two Authentication Modes:…
Read MoreDemystifying Load Balancer Setup in Oracle Cloud Infrastructure (OCI) Introduction Load Balancing allows customers to distribute web requests among a group…
Read MoreOverview Diving into the intricacies of Oracle Clusterware management, this comprehensive guide elucidates the meticulous steps involved in the process of deleting and adding RAC nodes within the Oracle environment. …
Read MoreOverview of blog In this blog post, we will explore a comprehensive solution to resolve the issue of ‘oracle.rdbms.deconfig, 19.0.0.0.0’: Cannot delete file ‘/usr/local/oracle/19.3.0.0/suptools/tfa’ and the subsequent ‘CheckApplicable’ prerequisite failure.…
Read MoreA failover is performed only when the primary database becomes unavailable, and there is no possibility of recovering the primary database. Steps involve in failover Connect to Physical Standby…
Read MoreFortifying Oracle Identity Cloud Service with Multifactor Authentication (MFA) Introduction Oracle Identity Cloud Service employs MFA, where users utilize two-factor verification, incorporating extra information or a second device during logins…
Read MoreBlock changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all data blocks to identify which blocks have changed, RMAN uses this file to identify the changed blocks that need to be backed up. TO ENSURE THE CURRENT PERFORMANCE OF INCREMENTAL BACKUPS: SQL> select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time, to_char(END_TIME,’mm/dd/yy hh24:mi’) end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; The above command will show the performance of daily incremental backups. i.e., How many hours the database backup is running before enabling the block change tracking. TO ENSURE THE BLOCK CHANGE TRACKING IS ENABLED IN THE DATABASE: SQL> select status, filename from v$block_change_tracking; It will show the block change tracking is enabled in our database or not. If it shows disabled, we want to enable the parameter by issue the below command. SQL> alter database enable block change tracking; NOTE:- After enables the BLOCK_CHANGE_TRACKING, wait for a day to complete the database backup. Then issue the above command to ensure the incremental backup performance. It will show you the positive differences compares to the earliest performance.
Read MoreORA-20004: Error in sending an Email – You have exceeded the maximum number of email messages per workspace. Please contact your administrator. REASON: Actually, Number of mails can be sent…
Read More