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