Remove Backup Remove Database Administration Remove White Paper
article thumbnail

Automation in Oracle EBS – It Can Be Done!

Datavail

Datavail has built a plug-and-play automation library specifically for our Oracle EBS clients, with dozens of scripts for automating database administration work. Common maintenance activities (including startups and shutdowns, reorganizing database tables and indexes, collecting schema statistics, and more). Patch management.

article thumbnail

Current DBA Trends: Adapting to a Data-Driven and Hybrid Environment

Datavail

There is also a shift in database administration as organizations have more options in how they want to be involved in the management of their systems. Jobs such as OS patching, database software installation and upgrades, database backups, disaster recovery, and more can be handled automatically.

article thumbnail

A PostgreSQL 13 Feature Deep-dive

Datavail

You can use EXPLAIN to look up WAL usage, keep an eye on streaming base backups, and learn more about the progress of ANALYZE operations. This version also adds a new backup feature called pg_verifybackup. As the name implies, you’re able to check the data integrity of your PostgreSQL backups.

Backup 52
article thumbnail

Keeping Your Data Secure and Resilient with MariaDB

Datavail

MariaDB Enterprise Backup: This backup option allows you to leverage full and incremental backups to restore individual tables and full databases. When you backup data with this feature, MariaDB goes through non-blocking stages to avoid interruptions in writing and changing schemas. Read This Next.

article thumbnail

SQL on Linux: Creating, Backing up & Restoring a Database

Datavail

Creating, backing up, and restoring a database are critical databases administration tasks that we must perform regardless of Operating System platform. Creating a Database and Verifying Its Data and Log Files. To create a database and verify its data and log files, perform the following steps: 1. Read This Next.

Linux 8
article thumbnail

What Do You Do When You Can’t Afford a Full-time Database Administrator?

Datavail

What happens when you need a database administrator but a full-time employee is beyond your reach, or you have less than full-time workloads? Both situations are not ideal and cause issues that include: Poorly optimized database environments. IT staff burnout due to long hours and lack of backup coverage.

article thumbnail

Reason #1 to Migrate to MongoDB Atlas: Built-in Automation

Datavail

Our Reason #1 is Built-in Automation – more specifically, hardware provisioning, setup, and configuration; software patches and upgrades; and backups and disaster recovery. Backups and Disaster Recovery. You can’t protect your database from 100 percent of the potential disasters that it could face.