Um grande amigo me pediu uma ajuda para identificar um problema em um Data Guard, achei que seria legal compartilhar como fixar o problema do ORA-19909 Vamos ao nosso laboratório Primary:DB Name: DUSTOP Standby:DB Unique Name: DUTSB======== Redo apply no standby falhou repentinamente, conforme mostrado no alert.log: Thu Oct 09 14:40:13 CST 2023Media Recovery Log […] Read more
Vamos ao segundo dia que foi um dia bem movimentado e cheio de atividades muito legais. No inicio do dia 2 tive 2 sessões da minha empresa sobre Migration of a Fortune 50 Banking Client to a Multicloud Environment with OCI e Complex, Cross Platform Oracle Database and Applications Migration to OCI onde demonstramos nossos […] Read more
Hoje resolvi fazer um blog diferente é um mix de conteudo e claro estou fazendo no meu idioma para prestigiar nosso público no Brasil e trazer um pouco da experiência para aqueles que não puderam estar aqui em Las Vegas para presenciar este incrível clima. Começamos o dia com o Sejam Bem-Vindos. Este ano percebi […] Read more
Oracle Cloud Guard provides a unified view of your security posture across all Oracle Cloud Infrastructure (OCI) clients. Cloud Guard identifies new threats, detects misconfigured OCI resources, identifies any insecure activity across tenants, exposes malicious threat activities, and provides security administrators the visibility to triage and resolve cloud security issues. What Is Oracle Cloud Guard? Cloud […] Read more
Today, we are going to talk about the popular cloud computing platforms- AWS, Azure, Google Cloud, and Oracle Cloud. I decided to write this article to help when we work on multi-cloud projects, and sometimes the service nomenclature is not in memory. So here’s a list of the main features of the main cloud providers. I […] Read more
Creating a File Storage replication resource automatically creates an associated replication target resource. At the interval you specify, data is replicated from the source file system to the target file system. Replications require an unexported target file system that you can replicate data to. You can choose to create the target file system before you begin creating […] Read more
Eu precisava remover o HAIP do ODA após migrar para a versão 19.13.0.0.0 e decidi preparar este procedimento. Esse plano de ação deve exigir apenas uma reinicialização do clusterware versus correção, o que pode resultar em duas ou três reinicializações do clusterware. Vamos ao procedimento. 1. Backup gpnp profile [grid@testoda1 peer]$ cd /u01/app/19.0.0.0/grid/gpnp/’hostname’/profiles/peer[grid@testoda1 peer]$ cp […] Read more
A few days ago, the customer asked me if I could know the latency between the regions where Oracle offers service. This allowed me to create another blog about this feature available in the Network Command Center console. The inter-region latency dashboard offers detailed visibility of real-time and historical round-trip latency for OCI regions, empowering […] Read more
Um dos recursos do Oracle 19, 21c é que, quando um flashback ou uma recuperação pontual é executada no banco de dados principal em um Oracle Data Guard, a mesma operação também é executada no banco de dados standby. Após uma operação de flashback ou PITR, o banco de dados principal é aberto com a […] Read more
This article describes File Storage replication and provides details on how to replicate the data in one file system to another file system in the same region or a different region. Limitations and Considerations Your tenancy must be subscribed to the destination region for cross-region replication. Source Region Target Region Australia East (Sydney) Australia Southeast (Melbourne) Australia […] Read more
Introduction Data Preserving Reprovisioning enables reprovisioning of an already deployed Oracle Database Appliance system without modifying the storage and and the databases on the appliance. The advantage of this method over the regular upgrade process is that it has a much shorter upgrade path. This is achieved by saving the information of the source system, […] Read more
Today, I’m bringing you an article with the steps to update the ODA version to 19.17. What’s new? As usual, this version brings the latest PSUs to database and grid homes with their bug fixes. It also brings the latest 21.8 databases. The only new features the release note are: Which ODA is compatible with […] Read more
A friend called me asking for help because a tablespace did not reduce size after purging the data. I explained to him how to identify high-water marks, and decided to write this article. This article explains, with examples, how to view the high-water mark and when the high-water mark is reset. The queries in this […] Read more
Change Oracle DB name using NID: How to Change the DBID, DBNAME Using NID Utility (Doc ID 863800.1) 1. In Real Application Cluster, we need to set cluster_database parameter to false and mount an instance on only one node: sqlplus / as sysdba alter system set cluster_database=false scope=spfile; oracle@db01:~# . oraenv ORACLE_SID = [DUTSDB] ? […] Read more
