How To Upgrade Autonomous Health Framework on ZDL Manually

4 de junho de 2025

Autonomous Health Framework or only AHF, is a diagnostic and system performance framework designed to keep database systems healthy and running while minimizing human reaction time. If you tried to run ahfctl upgrade and for some reason you had problems with upgrade file, for example, network limitations to download it, let’s see how to upgrade … Mais How To Upgrade Autonomous Health Framework on ZDL Manually

Upgrading PostgreSQL on CentOS Linux 9

15 de maio de 2025

In this new article about PostgreSQL database, we will upgrade our PostgreSQL. I am using a CentOS Linux 9, aarch64 architecture. My environment is single database and server. I am not using clusters environments or features as well. I am using PostgreSQL, version 13. Let’s check it. Connected on Linux with postgres user, execute psql … Mais Upgrading PostgreSQL on CentOS Linux 9

How To Configure Remote Connection With PostgreSQL

26 de abril de 2025

On this second article regarding PostgreSQL Database, I will show which files should be edited to enable remote connection with PostgreSQL. First file to be edit is postgresql.conf, commonly found under data directory: Open the file and edit listen_addresses parameter. Uncomment line parameter and change value for asterisk ‘*’ to be possible connect for anywhere. … Mais How To Configure Remote Connection With PostgreSQL

How To Install PostgreSQL on CentOS Linux 9

22 de abril de 2025

On this my first article talking about PostgreSQL Database, I will describe how to install a PostgreSQL on CentOS Linux 9. I am using a CentOS aarch64 processor version, installed on VMWare Fusion. We will create a disk to store data and others files for PostgreSQL, to isolate database files of operational systems files. Below, … Mais How To Install PostgreSQL on CentOS Linux 9

Integrating Oracle and PostgreSQL via Heterogeneous Services

21 de fevereiro de 2025

In this article, I will show how to integrate an Oracle database with a PostgreSQL database. First, we need to gather all the necessary information, such as: Let’s validate if the firewall and SELinux are disabled on the PostgreSQL server. For CentOS and Red Hat 7 and higher, stop service this way: For lower: To … Mais Integrating Oracle and PostgreSQL via Heterogeneous Services

Error RMAN-20110 error: set_stamp set_count conflict During Catalog Resync in RMAN Backup on ZDL

10 de fevereiro de 2025

I faced in my costumer environment, the issue RMAN-20110, during primary RMAN backup execution. This environment has a primary and data guard databases. To simulate the issue before fix it, simple execute a resync catalog: No backup for that specific database, will execute until you fix it, so, this is a critical issue. To fix … Mais Error RMAN-20110 error: set_stamp set_count conflict During Catalog Resync in RMAN Backup on ZDL

Error RMAN-07540: Cleanup is required for the VPC user schema when connecting to the ZDL Recovery Appliance catalog

1 de fevereiro de 2025

The ZDL, like other Oracle appliances and technologies, can be managed from the Oracle Enterprise Manager, a graphical web tool, to manage its infrastructure. However, the tool has some bugs. This error appeared after the user responsible for the RMAN catalog in the ZDL was changed, where the OEM tries to create a catalog, with … Mais Error RMAN-07540: Cleanup is required for the VPC user schema when connecting to the ZDL Recovery Appliance catalog

Restore of a Datafile Not Part of the Oracle Data Dictionary Using ZDL Recovery Appliance

21 de janeiro de 2025

In the event of a datafile loss, which is not part of the SYSTEM, SYSAUX, or any other tablespace belonging to the Oracle data dictionary, you can execute the commands below to recover the datafile. Obviously, for this, you must ensure that your backups are up-to-date and intact. The tablespace will remain inaccessible until the … Mais Restore of a Datafile Not Part of the Oracle Data Dictionary Using ZDL Recovery Appliance

Restore of SYSTEM Datafile using ZDL Recovery Appliance in RAC Environment

11 de janeiro de 2025

In a situation where a datafile from the SYSTEM tablespaces is lost, you should execute the following commands to return the database to an operational state. Obviously, for this, you should have up-to-date and intact backups. The database will be inaccessible until a full restoration is completed. In the example below, we will use an … Mais Restore of SYSTEM Datafile using ZDL Recovery Appliance in RAC Environment

How to Restore Lost Control Files in a RAC Environment with Zero Data Loss

6 de janeiro de 2025

To restore a lost control file in a RAC environment, you must ensure that your backups are intact and up-to-date. The process is done in two stages. First, you will need to start only one instance in nomount mode and then perform the control file restore. Next, you will need to restart the instance and bring it … Mais How to Restore Lost Control Files in a RAC Environment with Zero Data Loss