AWS RDS Patching

0

Is there any way to roll back a RU (patch)? I'm running RDS Oracle 19c.

feita há 2 meses363 visualizações
3 Respostas
1

Hello,

Amazon RDS for Oracle does not support rollback operation. It supports neither major version downgrade [1], nor minor version downgrade [2]. Taking a snapshot beforehand is recommended for helping the rollback process should it become necessary.

[1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Oracle.Major.html

[2] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Oracle.Minor.htm

Regards,

Govardhanan.

profile pictureAWS
ESPECIALISTA
respondido há 2 meses
profile picture
ESPECIALISTA
avaliado há 2 meses
0

I want to perform a minor version downgrade from 2024 Jan RU to 2023 October RU. Does this operation cause any loss of data?

respondido há 2 meses
  • Since Amazon RDS for Oracle does not support rollback/downgrade in place, this would mean going back to the snapshot created before the upgrade. If that is what you have in mind, all data change in the database that was made since the snapshot creation will be lost. On the other hand, if you do not want to loose any data, you may choose to create another database instance with the older minor version (Oracle OCT-2023 RU in your case), and copy the data from the upgraded instance (Oracle JAN-2024 RU). Further in this case, if you have any means available to replay all the transactions since upgrade, then you could create the new instance using the snapshot you have taken before the upgrade and then replay the transactions there to catch up.

0

For downgrading best and fastest way is to restore the pre upgrade snapshot but you will loose any data which is update/inserted after the upgrade ,you can always look to fix the issue in the new patch version ,else need to use native export/import between the Oracle Version or use any data migration tool to move the data based upon time-frame

AWS
respondido há um mês

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas