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
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
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
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
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
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
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
Neste artigo, vou explicar como realizar o duplicate database, utilizando um backup. Para realizar um duplicate com base em um backup, devemos logicamente primeiro criar um backup da base de origem: [oracle@oelmultiversion:db11g]$ rman target / Recovery Manager: Release 11.2.0.4.0 – Production on Fri Apr 1 07:13:24 2016 Copyright (c) 1982, 2014, Oracle and/or its affiliates. … Mais Duplicate Database via Backup
My Piece of Data 