Configuring Real-Time Redo Transport on Zero Data Loss Recovery Appliance

Real-Time Redo Transport is a mechanism used to send redo information directly from the buffer protected database to Zero Data Loss Recovery Appliance, minimizing the backup gap, turning restore point for protected databases using ZDLRA, with zero data loss. With each redo data sent to the ZDLRA, the appliance creates a backup, which, together with … Mais Configuring Real-Time Redo Transport on Zero Data Loss Recovery Appliance

Configuring Replication on Zero Data Loss Recovery Appliance

Oracle Zero Data Loss is the most powerfull Oracle Database Backup Appliance in the market. Full integration with RMAN, Data Guard, Multitenant Architecture and much more. On this article, let’s see how to Configure replication between 2 ZDLs, building a High Availability backup architecture. First, let’s explain all the information used in this article: We … Mais Configuring Replication on Zero Data Loss Recovery Appliance

Duplicate Database For Standby From Active Database

In this article, we will create a data guard standby database using RMAN active database. For this, we need to configure both servers, primary and secondary, with the listener.ora and tnsnames.ora files, ensuring cross-connections between the servers. This setup allows the primary server to access the database on the secondary server and vice versa. For primary database follow the … Mais Duplicate Database For Standby From Active Database

Duplicate Database Cluster Oracle Environment Using From Active Database

In this article, I will demonstrate how to perform data cloning using the duplicate database method without using a backup, or as some may prefer to call, via active database, on different servers. This method of database cloning without a backup is a feature introduced in version 11g and in previous versions, cloning was only possible if a full backup had … Mais Duplicate Database Cluster Oracle Environment Using From Active Database

How To Upgrade Autonomous Health Framework on ZDL Manually

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

Integrating Oracle and PostgreSQL via Heterogeneous Services

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

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

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

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

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