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

To recover a table, assuming you have a ZDL, you only need to have your backups up to date and intact. After this, you should execute the recovery, as in any Oracle environment, whether or not using a Recovery Appliance. In the example below, we will use a connection to the RMAN catalog, connecting to … Mais Recovering Table With ZDL Recovery Appliance

In this article, we will clone a RAC environment by extracting the backup of the source database from the Recovery Appliance. The clone will be created with a single-node environment and then converted to a cluster, as per the original environment. Below are some details in the table: Source Database ORDB Source Node 1 oraordb01 … Mais Duplicate Database Cluster Oracle Environment Using Backup From Zero Data Loss

At the end of a duplicate process and cluster environment configuration, I encountered an error commonly seen in network, communication, and net services configuration issues related to Oracle: The reason for this issue is almost unbelievable; however, it is simply a slash at the end of the ORACLE_HOME directory, as per Oracle’s Doc ID: Sqlplus … Mais Error ORA-12547: TNS:lost contact Trying To Connect on SQLPLUS After Duplicate