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

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

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

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

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

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