Restore from a snapshot (either manual or automated).<\/p>\n
NOTE: To restore the new instance with same as the original one, first the old\/original instance must be renamed to something else then the new instance from snapshot can be restored with the required name (can be same as old).<\/p>\n
Restoring from manual\/automated snapshot of AWS RDS Aurora.
\n1.\tIn AWS console, select the old\/existing database instance (apidbauu003) and rename the instance to something new (apidbauu003-corrupted).
\n2.\tselect the snapshot to be restored (e.g. apidbauu003-ort-test).
\n3.\tFrom snapshot actions, execute \u201crestore snapshot\u201d
\n4.\tUnder section \u201cSetting\u201d
\na.\tEnter the \u201cDB instance identifier\u201d name as the old name (apidbauu003).
\n5.\tUnder section \u201cNetwork & Security\u201d, verify following
\na.\tVPC
\nb.\tSubnet group
\nc.\tPublicly Accessible (Default No)
\n6.\tClick on button \u201cLaunch DB instance\u201d.
\n7.\tVerify the new instance created by following step 1-6.
\na.\tConnect to new Aurora instance database using MySQL client utility. Note: the old DB url should work as-is without any issue.
\nb.\t Execute sql statement to verify the data for any transaction\/master table.<\/p>\n","protected":false},"excerpt":{"rendered":"
Restore from a snapshot (either manual or automated). NOTE: To restore the new instance with same as the original one, first the old\/original instance must be renamed to something else then the new instance from snapshot can be restored with the required name (can be same as old). Restoring from manual\/automated snapshot of AWS RDS … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39],"tags":[12],"class_list":["post-293","post","type-post","status-publish","format-standard","hentry","category-aws","tag-aws"],"_links":{"self":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/comments?post=293"}],"version-history":[{"count":1,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/293\/revisions"}],"predecessor-version":[{"id":294,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/293\/revisions\/294"}],"wp:attachment":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/media?parent=293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/categories?post=293"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/tags?post=293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}