OCI immutable backup : version control

  Intro In today’s data-driven era, businesses leverage data analysis to seize opportunities and gain a competitive edge. This makes it crucial for organizations to have a robust disaster recovery (DR) plan. Most organizations leverage cloud backup features to store their data securely. When backups are in the public cloud, it is essential to ensure […]

Continue

Measuring Storage Performance for Oracle DBs

  Intro Storage vendors often provide extensive product performance data, but this information may not accurately predict how the storage will perform with an Oracle database. This article offers practical methods to evaluate storage system performance, including Oracle-provided utilities. There are two main methods to analyze the performance of storage. Oracle Orion Oracle procedure: DBMS_RESOURCE_MANAGER.calibrate_io. […]

Continue

Data guard : RMAN-06571: datafile 1430 does not have recoverable copy

  Intro  In the current data-driven era, businesses leverage data analysis to seize opportunities and gain a competitive edge. This makes it crucial for organizations to have a robust disaster recovery (DR) plan. Oracle Data Guard offers significant flexibility for maintaining data synchronization with the primary database. Additionally, it allows opening the database in snapshot […]

Continue

Data guard (DG) : ORA-01111 – Datafile not created on standby database

  Intro In today’s data-driven era, protecting data is paramount. Organizations must be prepared to address potential failures by implementing robust disaster recovery strategies. For those hosting critical data, having a disaster recovery (DR) site is essential. Oracle Data Guard offers a comprehensive solution for database disaster recovery, ensuring data protection and availability. In this […]

Continue

OLVM : Renew Engine and KVM Certificate

  Intro Virtualization made a significant change in the IT (Information Technology) industry. This technology helped many organizations to use server resources efficiently. Even though cloud technology is emerging some companies are not ready to move their workloads to the cloud due to data sensitivity and business obstacles. So the best cost-effective option is to […]

Continue

OCI DB Server – Troubleshoot missing LVM

  Intro  We are in the cloud era and many organizations are absorbing cloud technologies to get a competitive advantage over others. The cloud market is vast, with a diverse selection of services. It’s not easy to select a suitable cloud platform for an organization.  Oracle cloud platform is the number one platform to host […]

Continue

OCI DBCS : Backup using OCI backup module

  Intro  We live in a cloud era and Many organizations across various industries are leveraging cloud technology to enhance their operations, improve scalability, increase flexibility, and reduce costs. Last few years Oracle has been making significant progress on hosting database workload in Oracle Cloud Infrastructure. Also provides many cloud services and Many companies use […]

Continue

OLVM : Upgrade from 4.4 to 4.5

Intro  VMware vSphere has long held the crown as the leading on-premises server virtualization solution across businesses of all sizes. Its dominance stems from being the pioneer in offering a server virtualization solution tailored for standard x86 servers. Its robust feature set, including application isolation, workload portability, scalability, top-of-rack virtualization, storage virtualization, high availability options, […]

Continue

MySQL – Heatwave [In Memory Query Accelerator] with Lakehouse – Part 1

  Intro  This is the data era and most organizations are investing more in data analytics.  Data analytics needs more processing and storage.  To get a competitive advantage over other organizations invest more to gain more performance, for analytics database performance is really a key.  OLAP (Online Analytics processing) databases are more focused on the […]

Continue