Jone Jarouj

Using Recover Standby Database From Service To Fix Physical Data Guard

11 de dezembro de 2024

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

Recovering Table With ZDL Recovery Appliance

8 de dezembro de 2024

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

Safe Process To Reboot Storage Server on Exadata Hardware For Maintenance

4 de dezembro de 2024

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

Duplicate Database Cluster Oracle Environment Using Backup From Zero Data Loss

27 de novembro de 2024

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

Error ORA-12547: TNS:lost contact Trying To Connect on SQLPLUS After Duplicate

26 de novembro de 2024

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

How to Rename a Protected Database Name on ZDL

16 de novembro de 2024

For any reason you need to change protected database name on ZDL, such as after enroll a Data Guard on configuration or migrating databases with same DBID, but different names on the cluster, you can use an internal command to change that name. If you try change the names directly, you will get an error … Mais How to Rename a Protected Database Name on ZDL

NOTE: unable to execute orapwd… ret:255 sig:0 err: ASMCMD-9454 Creating orapw file Inside ASM

29 de outubro de 2024

This week, creating a new database, I faced an issue, already got for me sometimes ago, but I didn’t remember how I fixed that. So I decide to document because, usually, when we have to duplicate or restore a database, tables and schemas as well, is an urgent task for our customers. I faced that … Mais NOTE: unable to execute orapwd… ret:255 sig:0 err: ASMCMD-9454 Creating orapw file Inside ASM

Adding New Routes On OEM Server Operational System to Fix Monitoring ZDL Connectivity

1 de outubro de 2024

Some weeks ago, I went through a situation where client monitoring OEM agent was not able to connect to Oracle Enterprise Manager to monitor the Oracle Zero Data Loss. We received the error message below: “Communication between the Oracle Management Service to the Agent is unavailable. Any features or displayed information requiring this communication will … Mais Adding New Routes On OEM Server Operational System to Fix Monitoring ZDL Connectivity

Configurando Oracle Data Guard 19c Com PDB RAC Para Single

7 de fevereiro de 2024

Devido a algumas duvidas executando o processo de criação do Oracle Data Guard Fisico, em um ambiente onde o primary é um ambiente RAC e o standby, um ambiente single node, ambos Multitenant, resolvi escrever este artigo. HOSTNAME VERSÃO BANCO DE DADOS SISTEMA OPERACIONAL FUNÇÃO orarac01 19.3.0.0 Oracle Linux 7.9 Primário orarac02 19.3.0.0 Oracle Linux 7.9 … Mais Configurando Oracle Data Guard 19c Com PDB RAC Para Single

Configurando Replicação Cruzada no Zero Data Loss Recovery Appliance (Backup Anywhere)

13 de abril de 2023

Anteriormente, aprendemos como configurar a replicação do Zero Data Loss, unilateralmente, de um upstream para um downstream, formando um ambiente de alta disponibilidade. Neste artigo, utilizaremos a mesma configuração ja realizada antes, e adicionaremos apenas algumas configurações a mais, para que o downstream RAHA2, também seja um upstream, enviando backups para o RAHA1, que agora … Mais Configurando Replicação Cruzada no Zero Data Loss Recovery Appliance (Backup Anywhere)