This blog demonstrates how to do minor version upgrades and major version upgrades against SQL server RDS on AWS.
This post also addresses some errors like ‘InvalidParameterCombination’, etc.
Read more of this content when you subscribe today.
Poor application design can cause excessive connections to Oracle database, the idle sessions stuck in Oracle database forever, finally the ORA-00020 error occur in alert log.
Certainly DBA can write a job to kill the idle sessions periodically. Instead, here we will take advantage of Oracle features to terminate idle sessions in Oracle database automatically.
Read more of this content when you subscribe today.
PostgreSQL RDS instance got “No space left on device” errors, even RDS storage auto scaling enabled. The storage can only be extended after at least 6 hours.
As for now, although automatic scaling helps you to increase storage on your RDS instance dynamically, you should still configure the initial storage for your DB instance to an appropriate size for your typical workload.
Auto Scaling will kick in when these factors apply:
We can also see, that the minimum the storage will increase is either 5GB or max 10% of your current allocated storage. That means that if you have an instance of 200Gb storage right now, your max ‘auto allocated’ storage space would be +20Gb of 200Gb which would be 220Gb. This will not be able to change for at least 6 hours.
Remember 6 hours policy when using “auto scaling”.
While running an AWS DMS task for migrating on-premise Oracle to AWS PostgreSQL RDS, some tables records are fully loaded into target database. From Table Statistics, it shows some tables validations are pending forever without progressing at all.
Check “Migration task logs”, it just says :
[TASK_MANAGER]I:All tables are loaded.waiting for validation to finish...
(replicationtask.c:1234)
Read more of this content when you subscribe today.
Some times we see “Mismatched records” from AWS DMS validation.
To check what records are mismatching between Source and Target database.
Read more of this content when you subscribe today.
Make DBA Life Easy 