Eclipsys Blog
Latest Posts
Exadata Exascale and What it Means for Your Oracle Workloads
Last week, Oracle Exadata Exascale was released, and it is one of the features that I have been most excited about in a while. I will be writing a couple of blogs around the..
OCI Immutable Backup: Version Control
Introduction 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..
Data Guard: RMAN-06571: Datafile 1430 Does Not Have Recoverable Copy
Introduction 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..
Data Guard (DG): ORA-01111 – Datafile Not Created on StandBy Database
Introduction In today’s data-driven era, protecting data is paramount. Organizations must be prepared to address potential failures by implementing robust disaster recovery..
Oracle Database 23ai: Fetch Top-N Rows Per Group Queries
Overview: Oracle 23ai introduces partition by clause in fetch first clause to get top-N rows per group. A query’s syntax SELECT …….. FROM …….. ORDER BY , FETCH FIRST , ROWS ONLY..
Oracle 23ai: JSON Schema Support
Overview: Oracle first introduced the ability to display a JSON schema when they introduced the JSON Data in Oracle 12.2 but without the option to validate the structure of JSON..
OLVM : KVM Certificate Renewal
Intro Virtualization has revolutionized the IT industry by enabling organizations to utilize server resources more efficiently. Despite the rise of cloud technology, many..
How to create a CentOS 7 Virtual Machine on Windows using Vagrant
Vagrant is an open-source command-line tool for creating and managing virtual machine environments. Although virtualization can be time-consuming, especially with open-source..
Restore a Database in the MS SQL Server Always On Availability Group
Prerequisites 1. Backup File: Ensure you have a valid full backup of the database you want to restore. I used AdventureWorks2019.bak for my test. 2. Availability Group..
Popular Post
