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

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

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

Error ORA-01400: cannot insert NULL into (“RASYS”.”BCF”.”CKP_TIME”) on ZDL Recovery Appliance Catalog

Due to a series of tests performed in a development environment, we forced the cancellation of some operations that were being executed on ZDL. As a result, metadata became lost and inconsistent, with missing records and values in required fields in one of the internal views of the RASYS user. The error below was encountered … Mais Error ORA-01400: cannot insert NULL into (“RASYS”.”BCF”.”CKP_TIME”) on ZDL Recovery Appliance Catalog

Rename Datafile on Physical Data Guard Fixing Error ORA-01111 and ORA-01110

Sometimes, because you forget to set standby_file_management to AUTO for example, or any other reason you can get the issues below on alert log or starting database, you can rename datafile with a new feature on Data Guard. This tip help you fix the issue without copy datafiles via RMAN or have to set tablespaces … Mais Rename Datafile on Physical Data Guard Fixing Error ORA-01111 and ORA-01110

Using Recover Standby Database From Service To Fix Physical Data Guard

Oracle Data Guard is a secondary database environment used for disaster recovery, failover, or data recovery, however, this environment can also experience failures, such as synchronization issues, maintenance, and others. Oracle has simplified the process of fixing the database in the Data Guard environment with the command Recover Standby Database From Service, which uses a connection … Mais Using Recover Standby Database From Service To Fix Physical Data Guard

Safe Process To Reboot Storage Server on Exadata Hardware For Maintenance

If you work with Exadata, ZDL or any other Engineered System that you use Exadata hardware and need a hardware part replacement on storage server, you can follow the steps below to reboot the hardware safely, without impact the ASM structure. I my example, I am going to replace a controller disk battery on a … Mais Safe Process To Reboot Storage Server on Exadata Hardware For Maintenance