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
Lets suppose you have been requested to refresh a TEST/DEV Database and you don’t have access to the source DB, just access to the backups someone created. In this case, this is a Windows environment and we are going to assume the following information: DB and Archive log backups located under: “D:\RMAN\Backup\”Control file backup to... » read more
If you have set use_large_pages=ONLY, server need to have enough huge pages to allocate the SGA in the number of pages available, if not, you might get this error while trying to start instance: In this system you have only enough pages to allocate 17G and you require 28G, not good.How do you fix? You... » read more
Here an easy script to run a backup an in this case with a 30 day retention: Post Views: 740
I had this issue while installing grid in my lab.Checked everything: ping to both nodes, ssh to both nodes both ways… all ok, but still not able to run sshUserSetup.sh: Well… what was the problem? “racnode1 racnode2” vs “racnode1 racnode2” ( the “)And now it runs ok: Post Views: 1,831
If AUDIT_TRAIT is set to DB: If AUDIT_TRAIT is set to XML: In this case, this is the agent configured with a invalid password. Post Views: 1,468
Sometimes you might see this error in a Standby DB and MRP fails: Now, how to fix and restart MRP? Post Views: 1,890
You have been requested to check how much a DB is generating on archive logs, it can be for FRA size planing, standby lag analysis…. you name it. We can see here DB has the higher load during 1am to 3am. Here you can get the size it is generating per day: Post Views: 803
Sometimes you are doing a cloud patch precheck and error is a bit cryptic, it even says “ready to apply patch”! Now, if you try from the other node it can give you a hint: Somehow it can not copy file from DBNODE_B to DBNODE_A, and indeed, we tried to ssh both ways and we... » read more
For this first post, lets start with something easy that everyone that manages a DB should know. You have been requested to kill everything that RMAN is running for whatever reason. It can be backup is no longer valid or it is generating impact in performance, which needs to be resolved right away. Do you... » read more