スキップしてコンテンツを表示

Lost a database after restoring from RDS snapshot

0

After restore a RDS snapshot, a database is lost.

The snapshot is created at April 30, 2024, version Mysql 5.7.44, us-west-1c

Then I found some logs when creating the snapshot, it shows "Unknown database" just seconds before shutting down the plugins, and preparing for creating snapshot.

2024-04-30T01:40:01.919975Z 141860 [Note] Unknown database 'portal_v2'

Update: I tried Export to S3, and I got the info.json, it says totalExportedDataInGB is 0.

{"exportTaskIdentifier":"portal","sourceArn":"arn:aws:rds:us-west-1:953153256941:snapshot:billing-snapshot","exportOnly":[],"snapshotTime":"Apr 30, 2024, 1:48:23 AM","taskStartTime":"Jun 4, 2024, 8:54:33 PM","taskEndTime":"Jun 4, 2024, 8:56:00 PM","s3Bucket":"sddesign-rds","s3Prefix":"","exportedFilesPath":"portal","iamRoleArn":"arn:aws:iam::953153256941:role/service-role/rds-importing","kmsKeyId":"arn:aws:kms:us-west-1:953153256941:key/d687a723-42fa-45c7-8bb0-f721aa1e8285","status":"COMPLETE","percentProgress":100,"totalExportedDataInGB":0.0}

Any suggestions? much appreciate!

質問済み 2年前489ビュー

1回答
1

Based on the information you've provided "Unknown database 'portal_v2'", it seems that the database 'portal_v2' was already missing or inaccessible at the time the snapshot was created. Here are some suggestions and points to consider:

  1. Look for any logs around April 30, 2024, that might indicate the database was dropped or renamed.

  2. Since the export to S3 shows 0 GB of data, it's possible the snapshot itself is corrupted or empty. Try restoring to a new RDS instance to confirm.

  3. Look for any events around the time of the snapshot that might indicate issues with the database or instance.

  4. Ensure there were no storage-related issues on the original RDS instance that could have prevented proper snapshot creation.

  5. If available, try a point-in-time recovery to a time shortly before the snapshot was taken.

If you've exhausted these options, it might be worth contacting AWS Support for more in-depth investigation.

Also for future prevention, it's crucial to regularly verify the integrity of your backups and snapshots, and to maintain multiple backup strategies.

AWS
エキスパート

回答済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

関連するコンテンツ