ORA-01274: cannot add datafile – file could not be created
Sometimes you might see this error in a Standby DB and MRP fails: Now, how to fix and restart MRP? Post Views: 2,423
Sometimes you might see this error in a Standby DB and MRP fails: Now, how to fix and restart MRP? Post Views: 2,423
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: 1,616
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