Categoria: Oracle

Error ORA-14404: partitioned table contains partitions in a different tablespace During Duplicate Database With Tablespace Parameter

7 de julho de 2026

Last week I got an issue trying to duplicate a database with only READ WRITE tablespaces for a specific table that had many partitions, some of them READ ONLY and others, those I wanted, READ WRITE. The goal for this operation is save time in a disaster event. Unfortunately, using SKIP READONLY command parameter was … Mais Error ORA-14404: partitioned table contains partitions in a different tablespace During Duplicate Database With Tablespace Parameter

Configuring Cross Replication on Zero Data Loss Recovery Appliance Backup Anywhere

15 de janeiro de 2026

Previously on article https://mypieceofdata.com/2025/07/21/configuring-replication-on-zero-data-loss-recovery-appliance/, we learned how to configure ZDLRA replication in a one-way setup, from an upstream to a downstream, creating a high-availability environment. In this article, we will use the same configuration previously implemented and add only a few additional settings so that the downstream RAHA2 also becomes an upstream, sending backups to … Mais Configuring Cross Replication on Zero Data Loss Recovery Appliance Backup Anywhere

Recriating a Standby Database Using Incremental Backup

8 de janeiro de 2026

On this simple article, I am going to show you how to recreate and fix a simple standby database, not using data guard feature, using an incremental backup. Initially, if database is not open, so, open the database in READ ONLY mode. On standby, do that: Now, we need to find the latest standby SCN, … Mais Recriating a Standby Database Using Incremental Backup

Alter Flash Cache Mode on Storage Server in Exadata and Zero Data Loss Recovery Appliance

10 de dezembro de 2025

Flash Cache is a mechanism that use the high-performance flash storage on Exadata Storage Servers to keep frequently used data and index blocks readily available. It operates as a fast cache between the slower disks and the database servers, greatly reducing I/O wait time and improving overall system performance for both OLTP and data warehousing. … Mais Alter Flash Cache Mode on Storage Server in Exadata and Zero Data Loss Recovery Appliance

How to Set SSH User Equilance in All Storage Server in Exadata and Zero Data Loss Recovery Appliance

27 de novembro de 2025

Many tasks in an Exadata and Zero Data Loss Recovery Appliance environment, you can do connected in one server and then, execute the operation in many servers and storage servers in one time. But for this, as premise, all ssh connections must be done without password, using user key equivalence. One way to set this … Mais How to Set SSH User Equilance in All Storage Server in Exadata and Zero Data Loss Recovery Appliance

Adding More Space on Zero Data Loss Recovery Appliance Backup Export ACFS Directory

12 de novembro de 2025

Oracle Zero Data Loss Recovery Appliance run every day a backup export of RMAN catalog database, ZDLRA`s database. These backups exported are stored on /raacfs/raadmin ACFS directory that belong the disk group DELTA. shared by all of dbnodes of appliance. As the database increases and the backups as well, you will have to increase this … Mais Adding More Space on Zero Data Loss Recovery Appliance Backup Export ACFS Directory

Configuring Backup and Redo Failover of Protected Databases from Primary ZDLRA to an Alternate ZDLRA During Maintenance or Unavailability, Without Creating a Backup

21 de agosto de 2025

In an environment where Backup and Redo Apply are configured, a protected database sends backups and redos to a primary Recovery Appliance under normal circumstances. When the primary appliance is unavailable, the protected database sends backups and redos to an alternate Recovery Appliance until the service on the primary is restored. The alternate appliance does … Mais Configuring Backup and Redo Failover of Protected Databases from Primary ZDLRA to an Alternate ZDLRA During Maintenance or Unavailability, Without Creating a Backup

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

29 de julho de 2025

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

21 de julho de 2025

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