True Cache is an in-memory, read-only replica database, similar to Oracle Active Data Guard but without disk storage. On this activity we are going to create a True Cache DB but I’m limited to the memory of my lab and I can not create a huge DB to test, so DB needs to be small.We... » read more
On this activity we are going to setup Dataguard at PDB level.Here both DB’s are running on the same host but on different ORACLE_HOME.This was first introduced on 21c and we are going to follow the Oracle documentation from here. First DB (as SOURCE DB): Second DB (as TARGET DB): 1:- Both DB’s need to... » read more
You have a standby DB out of sync and all logs on primary are gone. At this stage you have 2 options: 1:- rebuild standby 2:- Rollforward standby What about a “one line” command that does automatically all the steps you usually do on a rollforward? Here is the magic: After this, you just need... » read more
On this activity we are going to generate snapshots on an active standby so we can be able to create AWR reports. This is our setup: We need to perform the following steps to enable AWR reporting from a physical standby database. 1:- Unlock SYS$UMF user and reset the password. SYS$UMF account is used to... » read more
On this activity we are going to create a Physical Standby from a 19c in CDB configuration: These are the details for the primary DB: Our plan is to create a Standby DB with these details: STEPS: 1:- Prepare Primary database Enable force logging and archivelog mode: Create Standby Redo Log (SRL) files: **We are... » read more
On this practice, we are going to configure DATAGUARD BROKER in a new PRIMARY/STANDBY configuration and see what errors we get since this is a new setup. This is our current lab: 1:- Add the DG broker files to ASM on both primary and Standby: 2:- Start DG broker at DB level on both systems:... » read more
This error usually is because of password file mismatch: someone updated in primary and forgot to pass across to standby nodes, missed a node… but what if password file in primary and standby is the same? In this case, password files are correct so PRIMARY should not have issues sending logs,right? But no, instead it... » read more
Sometimes you might see this error in a Standby DB and MRP fails: Now, how to fix and restart MRP?