{"id":5717,"date":"2019-07-10T09:00:56","date_gmt":"2019-07-10T00:00:56","guid":{"rendered":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/?p=5717"},"modified":"2019-08-08T12:37:01","modified_gmt":"2019-08-08T03:37:01","slug":"amazon-s3-rds-oracle","status":"publish","type":"post","link":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/amazon-s3-rds-oracle","title":{"rendered":"Amazon S3\u3092\u5229\u7528\u3057\u305fAmazon RDS for Oracle\u3078\u306e\u30c7\u30fc\u30bf\u79fb\u884c"},"content":{"rendered":"<h2 class=\"posthl02\">\u306f\u3058\u3081\u306b<\/h2>\n<p>AWS\u306b\u76f4\u63a5\u63a5\u7d9a\u3067\u304d\u306a\u3044\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u306eOracle Database\u3092RDS\u306b\u79fb\u884c\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u3053\u306e\u5834\u5408\u3001RDS\u306b\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066Oracle Data Pump\u3067\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u304c\u3001Amazon EC2\u306b\u4e00\u65e6\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u5f8c\u3001PL\/SQL\u306eUTL_FILE\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u4f7f\u3063\u3066RDS\u306e\u30c7\u30a3\u30b9\u30af\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3068\u3044\u3046\u6d41\u308c\u306b\u306a\u308a\u3001\u4f5c\u696d\u304c\u7169\u96d1\u3060\u306a\u3068\u611f\u3058\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n<p>AWS\u306e\u30b5\u30fc\u30d3\u30b9\u3092\u6d3b\u7528\u3057\u3066\u5b9f\u73fe\u3067\u304d\u306a\u3044\u3082\u306e\u304b\u3068\u8abf\u3079\u3066\u3044\u305f\u3068\u3053\u308d\u3001\u300c<a href=\"https:\/\/aws.amazon.com\/jp\/about-aws\/whats-new\/2019\/02\/Amazon-RDS-for-Oracle-Now-Supports-Amazon-S3-Integration\/\" target=\"_blank\" rel=\"noopener noreferrer\">Amazon RDS for Oracle \u304c Amazon S3\u3068\u306e\u7d71\u5408\u306b\u3088\u308b\u30c7\u30fc\u30bf\u9001\u53d7\u4fe1\u6a5f\u80fd\u306e\u30b5\u30dd\u30fc\u30c8\u3092\u958b\u59cb<\/a>\u300d\u3068\u3044\u3046\u8a18\u4e8b\u304b\u3089\u3001RDS\u304b\u3089S3\u306b\u683c\u7d0d\u3057\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u3092\u76f4\u63a5\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\u6a5f\u80fd\u304c\u5b9f\u88c5\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u5206\u304b\u308a\u307e\u3057\u305f\u3002\u30bf\u30a4\u30df\u30f3\u30b0\u3088\u304f\u5b9f\u88c5\u3055\u308c\u305f\u6a5f\u80fd\u3067\u3059\u306e\u3067\u3001\u4eca\u56de\u306f\u3053\u306e\u6a5f\u80fd\u3092\u4f7f\u7528\u3057\u3066\u30c7\u30fc\u30bf\u79fb\u884c\u3092\u884c\u3044\u3001\u305d\u306e\u624b\u9806\u306b\u3064\u3044\u3066\u3054\u7d39\u4ecb\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<h2 class=\"posthl02\">\u74b0\u5883\u306b\u3064\u3044\u3066<\/h2>\n<p>\u4eca\u56de\u4f7f\u7528\u3057\u305f\u74b0\u5883\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5842\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_000_02-e1560154522163.png\" alt=\"\" width=\"598\" height=\"211\" \/><br \/>\n\u79fb\u884c\u30c7\u30fc\u30bf\u306f\u30b9\u30ad\u30fc\u30de\u3092\u6307\u5b9a\u3057Data Pump\u3067\u4e8b\u524d\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n\u307e\u305f\u3001\u4ee5\u4e0b\u306e\u74b0\u5883\u306f\u69cb\u7bc9\u6e08\u307f\u3068\u3057\u307e\u3059\u3002<br \/>\n\u30fbEC2(\u64cd\u4f5c\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9)<br \/>\n\u3000\u3000OS\uff1aWindows 2012 R2<br \/>\n\u3000\u3000\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\uff1aOracle Database Client 12.2.0.1<br \/>\n\u30fbRDS<br \/>\n\u3000\u3000DB\u30a8\u30f3\u30b8\u30f3\uff1aOracle Database Standard Edition Two<br \/>\n\u3000\u3000DB\u30a8\u30f3\u30b8\u30f3\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\uff1aOracle 12.2.0.1<br \/>\n\u3000\u3000\u30aa\u30d7\u30b7\u30e7\u30f3\u30b0\u30eb\u30fc\u30d7\uff1aDB\u30a8\u30f3\u30b8\u30f3\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u5bfe\u5fdc\u3057\u305f\u3082\u306e\u3092\u4f5c\u6210<br \/>\n\u3000\u3000\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\uff1a\u64cd\u4f5c\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304b\u3089sqlplus\u3067\u306e\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u3059\u308b<\/p>\n<h2 class=\"posthl02\">\u5927\u307e\u304b\u306a\u4f5c\u696d\u306e\u6d41\u308c<\/h2>\n<p>\u4f5c\u696d\u524d\u306b\u5927\u307e\u304b\u306a\u6d41\u308c\u3092\u8aac\u660e\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<ul style=\"list-style-type: disc;\">\n<li>S3\u306e\u8a2d\u5b9a<br \/>\n\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u7f6e\u304f\u305f\u3081\u306e\u30d0\u30b1\u30c3\u30c8\u3092\u4f5c\u6210\u3057\u3001\u7aef\u672b\u7b49\u304b\u3089\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/li>\n<li>AWS Identity and Access Management (\u4ee5\u4e0bIAM)\u306e\u8a2d\u5b9a<br \/>\nRDS\u304b\u3089\u4f5c\u6210\u3057\u305f\u30d0\u30b1\u30c3\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u305f\u3081\u306eIAM\u30dd\u30ea\u30b7\u30fc\u3068\u30ed\u30fc\u30eb\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002<\/li>\n<li>RDS\u306e\u8a2d\u5b9a<br \/>\n\u4f5c\u6210\u3057\u305f\u30ed\u30fc\u30eb\u3092RDS\u306b\u5272\u308a\u5f53\u3066\u3001S3\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u6a5f\u80fd\uff08Amazon S3\u7d71\u5408\u6a5f\u80fd\uff09\u3092\u6709\u52b9\u306b\u3057\u307e\u3059\u3002<\/li>\n<li>RDS\u304b\u3089S3\u306e\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<br \/>\nAmazon S3\u7d71\u5408\u6a5f\u80fd\u3092\u4f7f\u7528\u3057\u3066RDS\u304b\u3089S3\u306e\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/li>\n<li>\u30a4\u30f3\u30dd\u30fc\u30c8\u6e96\u5099<br \/>\nRDS\u3067\u79fb\u884c\u5148\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002<\/li>\n<li>Data Pump\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a4\u30f3\u30dd\u30fc\u30c8<br \/>\nRDS\u3067Data Pump\u3092\u4f7f\u7528\u3057\u3001\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n<h2 class=\"posthl02\">\u8a2d\u5b9a\u624b\u9806<\/h2>\n<h3 class=\"posthl03\">S3\u306e\u8a2d\u5b9a<\/h3>\n<p>\u79fb\u884c\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3059\u308b\u305f\u3081\u306eS3\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002<br \/>\n\u30fbS3\u306b\u30d0\u30b1\u30c3\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059<br \/>\n\u30fb\u30d0\u30b1\u30c3\u30c8\u5185\u306bData Pump\u3067\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u306e\u307f\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u304a\u304d\u307e\u3059<\/p>\n<h3 class=\"posthl03\">IAM\u306e\u8a2d\u5b9a<\/h3>\n<h4 class=\"posthl04\">\u30dd\u30ea\u30b7\u30fc\u4f5c\u6210<\/h4>\n<p>RDS\u304cS3\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u70ba\u306b\u5fc5\u8981\u306a\u30dd\u30ea\u30b7\u30fc\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<br \/>\n\u30fbIAM\u7ba1\u7406\u753b\u9762\u3067\u300c\u30dd\u30ea\u30b7\u30fc\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u300c\u30dd\u30ea\u30b7\u30fc\u306e\u4f5c\u6210\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5788\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_001-e1559734819327.png\" alt=\"\" width=\"600\" height=\"256\" \/><\/p>\n<p>\u30fb\u300c\u30b5\u30fc\u30d3\u30b9\u306e\u9078\u629e\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5789\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_002-e1559734914381.png\" alt=\"\" width=\"552\" height=\"315\" \/><\/p>\n<p>\u30fb\u300cS3\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5790\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_003-e1559734946112.png\" alt=\"\" width=\"599\" height=\"228\" \/><\/p>\n<p>\u30fb\u300c\u30a2\u30af\u30b7\u30e7\u30f3\u300d\uff0d\u300c\u30a2\u30af\u30bb\u30b9\u30ec\u30d9\u30eb\u300d\uff0d\u300c\u30ea\u30b9\u30c8\u300d\u3092\u958b\u304d\u3001\u300cListBucket\u300d\u3092\u9078\u629e\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5791\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_004.png\" alt=\"\" width=\"344\" height=\"196\" \/><\/p>\n<p>\u30fb\u300c\u30a2\u30af\u30b7\u30e7\u30f3\u300d\uff0d\u300c\u30a2\u30af\u30bb\u30b9\u30ec\u30d9\u30eb\u300d\uff0d\u300c\u8aad\u307f\u8fbc\u307f\u300d\u3092\u958b\u304d\u3001\u300cGetObject\u300d\u3092\u9078\u629e\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5792\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_005-e1559734984270.png\" alt=\"\" width=\"431\" height=\"315\" \/><\/p>\n<p>\u30fb\u300c\u30a2\u30af\u30b7\u30e7\u30f3\u300d\uff0d\u300c\u30a2\u30af\u30bb\u30b9\u30ec\u30d9\u30eb\u300d\uff0d\u300c\u66f8\u304d\u8fbc\u307f\u300d\u3092\u958b\u304d\u3001\u300cPutObject\u300d\u3092\u9078\u629e\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5793\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_006-e1559735004487.png\" alt=\"\" width=\"601\" height=\"158\" \/><\/p>\n<p>\u30fb\u300c\u30ea\u30bd\u30fc\u30b9\u300d\u3092\u958b\u304d\u3001\u300cbucket\u300d\u884c\u306e\u300cARN\u306e\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5795\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_008.png\" alt=\"\" width=\"522\" height=\"164\" \/><\/p>\n<p>\u30fb\u300cBucket name\u300d\u306b\u4f5c\u6210\u3057\u3066\u304a\u3044\u305f\u30d0\u30b1\u30c3\u30c8\u540d\u3092\u5165\u529b\u3057\u3001\u300c\u8ffd\u52a0\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5796\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_009-e1559735074288-600x365.png\" alt=\"\" width=\"600\" height=\"365\" \/><\/p>\n<p>\u30fb\u300cobject\u300d\u884c\u306e\u300cARN\u306e\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5797\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_010.png\" alt=\"\" width=\"476\" height=\"192\" \/><\/p>\n<p>\u30fb\u300cBucket name\u300d\u306b\u4f5c\u6210\u3057\u3066\u304a\u3044\u305f\u30d0\u30b1\u30c3\u30c8\u540d\u3092\u5165\u529b\u3001\u300cObject name\u300d\u306b\u306f\u4f55\u3082\u5165\u529b\u305b\u305a\u3001\u53f3\u7aef\u306e\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3092\u30aa\u30f3\u306b\u3057\u3066\u300c\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5798\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_011-e1559735151962.png\" alt=\"\" width=\"457\" height=\"315\" \/><\/p>\n<p>\u30fb\u300c\u30dd\u30ea\u30b7\u30fc\u306e\u78ba\u8a8d\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5799\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_012-e1559735198390.png\" alt=\"\" width=\"505\" height=\"315\" \/><\/p>\n<p>\u30fb\u30dd\u30ea\u30b7\u30fc\u540d\u3092\u5165\u529b\u3057\u300c\u30dd\u30ea\u30b7\u30fc\u306e\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5800\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_013-e1559735223632.png\" alt=\"\" width=\"495\" height=\"315\" \/><\/p>\n<h4 class=\"posthl04\">\u30ed\u30fc\u30eb\u4f5c\u6210<\/h4>\n<p>RDS\u304cS3\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u70ba\u306b\u5272\u308a\u5f53\u3066\u308b\u30ed\u30fc\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<br \/>\n\u30fbIAM\u7ba1\u7406\u753b\u9762\u3067\u300c\u30ed\u30fc\u30eb\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u300c\u30ed\u30fc\u30eb\u306e\u4f5c\u6210\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5801\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_014-e1559735264377.png\" alt=\"\" width=\"347\" height=\"315\" \/><\/p>\n<p>\u30fb\u300c\u3053\u306e\u30ed\u30fc\u30eb\u3092\u4f7f\u7528\u3059\u308b\u30b5\u30fc\u30d3\u30b9\u3092\u9078\u629e\u300d\u3067\u300cRDS\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5802\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_015-e1559735282758.png\" alt=\"\" width=\"518\" height=\"315\" \/><\/p>\n<p>\u30fb\u753b\u9762\u4e0b\u306b\u300c\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u306e\u9078\u629e\u300d\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u300cRDS &#8211; Add Role to Database\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u300c\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\uff1a\u30a2\u30af\u30bb\u30b9\u6a29\u9650\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5803\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_016-e1559735305612.png\" alt=\"\" width=\"599\" height=\"278\" \/><\/p>\n<p>\u30fb\u4f5c\u6210\u3057\u305f\u30dd\u30ea\u30b7\u30fc\u3092\u9078\u629e\u3057\u300c\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\uff1a\u30bf\u30b0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5804\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_017-e1559735369854.png\" alt=\"\" width=\"462\" height=\"310\" \/><\/p>\n<p>\u30fb\uff08\u4efb\u610f\uff09\u30bf\u30b0\u3092\u8ffd\u52a0\u3057\u300c\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\uff1a\u78ba\u8a8d\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<\/p>\n<p>\u30fb\u30ed\u30fc\u30eb\u540d\u3092\u5165\u529b\u3057\u300c\u30ed\u30fc\u30eb\u306e\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5805\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_018-e1559735413386.png\" alt=\"\" width=\"369\" height=\"310\" \/><\/p>\n<h3 class=\"posthl03\">RDS\u306e\u8a2d\u5b9a<\/h3>\n<h4 class=\"posthl04\">\u30aa\u30d7\u30b7\u30e7\u30f3\u30b0\u30eb\u30fc\u30d7\u306e\u8a2d\u5b9a<\/h4>\n<p>RDS\u304b\u3089S3\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u6a5f\u80fd\u3092\u6709\u52b9\u306b\u3057\u307e\u3059\u3002<br \/>\n\u30fbRDS\u7ba1\u7406\u753b\u9762\u3067\u300c\u30aa\u30d7\u30b7\u30e7\u30f3\u30b0\u30eb\u30fc\u30d7\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5272\u308a\u5f53\u3066\u3066\u3044\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u30b0\u30eb\u30fc\u30d7\u306e\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3092\u30aa\u30f3\u306b\u3057\u3001\u300c\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5806\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_019-e1559735461394.png\" alt=\"\" width=\"600\" height=\"281\" \/><\/p>\n<p>\u30fb\u300c\u30aa\u30d7\u30b7\u30e7\u30f3\u300d\u3067\u300cS3_INTEGRATION\u300d\u3001\u300c\u30d0\u30fc\u30b8\u30e7\u30f3\u300d\u306f\u300c1.0\u300d\u3001\u300c\u3059\u3050\u306b\u9069\u7528\u300d\u306f\u300c\u306f\u3044\u300d\u3092\u9078\u629e\u3057\u300c\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5808\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_020-e1559735494663.png\" alt=\"\" width=\"534\" height=\"315\" \/><\/p>\n<p>\u30fb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u304c\u300c\u5909\u66f4\u4e2d\u300d\u304b\u3089\u300c\u5229\u7528\u53ef\u80fd\u300d\u306b\u306a\u3063\u305f\u4e8b\u3092\u78ba\u8a8d\u3057\u307e\u3059<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5809\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_021.png\" alt=\"\" width=\"550\" height=\"170\" \/><\/p>\n<h4 class=\"posthl04\">IAM\u30ed\u30fc\u30eb\u306e\u5272\u308a\u5f53\u3066<\/h4>\n<p>RDS\u306bIAM\u30ed\u30fc\u30eb\u3092\u5272\u308a\u5f53\u3066\u307e\u3059\u3002<br \/>\n\u30fbRDS\u7ba1\u7406\u753b\u9762\u3067\u300c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u5bfe\u8c61\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5987 size-full\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_022_02-e1561342977458.png\" alt=\"\" width=\"600\" height=\"253\" \/><\/p>\n<p>\u30fb\u753b\u9762\u6700\u4e0b\u90e8\u306e\u300cIAM\u30ed\u30fc\u30eb\u306e\u7ba1\u7406\u300d\u3067\u3001\u300c\u3053\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b IAM \u30ed\u30fc\u30eb\u3092\u8ffd\u52a0\u300d\u3067\u4f5c\u6210\u3057\u305f\u30ed\u30fc\u30eb\u3001\u300c\u6a5f\u80fd\u300d\u3067\u300cS3_INTEGRATION\u300d\u3092\u9078\u629e\u3057\u3001\u300c\u30ed\u30fc\u30eb\u306e\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5811\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_023-e1559735609292.png\" alt=\"\" width=\"598\" height=\"196\" \/><\/p>\n<p>\u30fb\u300c\u30b9\u30c6\u30fc\u30bf\u30b9\u300d\u304c\u300c\u4fdd\u7559\u300d\u304b\u3089\u300c\u30a2\u30af\u30c6\u30a3\u30d6\u300d\u306b\u306a\u3063\u305f\u4e8b\u3092\u78ba\u8a8d\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5988 size-medium\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_024_02-660x354.png\" alt=\"\" width=\"660\" height=\"354\" \/><\/p>\n<p>\u30fb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u304c\u300c\u5909\u66f4\u4e2d\u300d\u304b\u3089\u300c\u5229\u7528\u53ef\u80fd\u300d\u306b\u306a\u3063\u305f\u4e8b\u3092\u78ba\u8a8d\u3057\u307e\u3059<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5809\" src=\"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-content\/uploads\/2019\/06\/5114_201906_021.png\" alt=\"\" width=\"550\" height=\"170\" \/><\/p>\n<h3 class=\"posthl03\">RDS\u304b\u3089S3\u306e\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/h3>\n<p>\u30fb\u64cd\u4f5c\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3067\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u3092\u8d77\u52d5\u3057\u3001sqlplus\u3092\u4f7f\u7528\u3057\u3066RDS\u306b\u63a5\u7d9a\u3057\u307e\u3059<\/p>\n<pre class=\"lang:default decode:true\">sqlplus \u30de\u30b9\u30bf\u30fc\u30e6\u30fc\u30b6\u30fc\u540d\/\u30de\u30b9\u30bf\u30fc\u30d1\u30b9\u30ef\u30fc\u30c9@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))<\/pre>\n<p>\u30fb\u30d5\u30a1\u30a4\u30eb\u304c\u683c\u7d0d\u3055\u308c\u308bDATA_PUMP_DIR\u914d\u4e0b\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u78ba\u8a8d\u3057\u307e\u3059<\/p>\n<pre class=\"lang:default decode:true\">select * from table (rdsadmin.rds_file_util.listdir(p_directory =&gt; 'DATA_PUMP_DIR'));<\/pre>\n<p>\u30fbRDS\u304b\u3089S3\u306e\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059<\/p>\n<pre class=\"lang:default decode:true\">select rdsadmin.rdsadmin_s3_tasks.download_from_s3(p_bucket_name =&gt; '\u30d0\u30b1\u30c3\u30c8\u540d', p_directory_name =&gt; 'DATA_PUMP_DIR') AS TASK_ID FROM DUAL;\r\n<\/pre>\n<p>\u3000\u30b3\u30de\u30f3\u30c9\u306b\u9593\u9055\u3044\u304c\u306a\u3051\u308c\u3070TASK ID\u304c\u8fd4\u3055\u308c\u307e\u3059<\/p>\n<pre class=\"nums:false lang:default decode:true\">TASK_ID\r\n--------------------------------------------------------------------------------\r\n1559639797887-38<\/pre>\n<p>\u30fb\u5b9f\u884c\u30ed\u30b0\u3092\u78ba\u8a8d\u3057\u307e\u3059<br \/>\n\u3000\u524d\u306e\u624b\u9806\u3067\u53d6\u5f97\u3057\u305fTASK ID\u3092\u4f7f\u7528\u3057\u3066\u5b9f\u884c\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u6307\u5b9a\u3057\u3001\u5b9f\u884c\u30ed\u30b0\u3092\u8868\u793a\u3055\u305b\u307e\u3059<\/p>\n<pre class=\"lang:default decode:true\">select text from table(rdsadmin.rds_file_util.read_text_file('BDUMP','dbtask-1559639797887-38.log'));<\/pre>\n<p>\u3000&#8221;The task finished successfully&#8221;\u3068\u8868\u793a\u3055\u308c\u3066\u3044\u308c\u3070\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u306f\u6210\u529f\u3057\u3066\u3044\u307e\u3059<\/p>\n<pre class=\"nums:false lang:default decode:true\">S3 object or objects from bucket name \u30d0\u30b1\u30c3\u30c8\u540d with key EXPORT.DMP to the lo\r\ncation \/rdsdbdata\/datapump.\r\n\r\n2019-06-04 09:16:59.698 UTC [INFO ] The task finished successfully.<\/pre>\n<h3 class=\"posthl03\">\u30a4\u30f3\u30dd\u30fc\u30c8\u6e96\u5099<\/h3>\n<p>\u30fb\u30b9\u30ad\u30fc\u30de\u4f5c\u6210\u3057\u307e\u3059<\/p>\n<pre class=\"lang:default decode:true\">CREATE USER TS_USR IDENTIFIED BY \u30d1\u30b9\u30ef\u30fc\u30c9;<\/pre>\n<p>\u30fb\u8868\u9818\u57df\u306e\u4f5c\u6210\u3057\u307e\u3059<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLESPACE \u8868\u9818\u57df\u540d DATAFILE SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;<\/pre>\n<p>\u30fb\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30c6\u30fc\u30d6\u30eb\u30b9\u30da\u30fc\u30b9\u3092\u5909\u66f4\u3057\u307e\u3059<\/p>\n<pre class=\"lang:default decode:true\">ALTER USER \u30e6\u30fc\u30b6\u30fc\u540d DEFAULT TABLESPACE \u8868\u9818\u57df\u540d TEMPORARY TABLESPACE TEMP;<\/pre>\n<p>\u30fb\u5fc5\u8981\u306a\u6a29\u9650\u4ed8\u4e0e\u3092\u884c\u3044\u307e\u3059<\/p>\n<pre class=\"lang:default decode:true\">GRANT CONNECT, RESOURCE TO \u30e6\u30fc\u30b6\u30fc\u540d;\r\nALTER USER \u30e6\u30fc\u30b6\u30fc\u540d QUOTA UNLIMITED ON USERS;\r\nGRANT UNLIMITED TABLESPACE TO \u30e6\u30fc\u30b6\u30fc\u540d;\r\nGRANT read,write on directory DATA_PUMP_DIR to \u30e6\u30fc\u30b6\u30fc\u540d;<\/pre>\n<h3 class=\"posthl03\">Data Pump\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a4\u30f3\u30dd\u30fc\u30c8<\/h3>\n<p>\u30fbData Pump\u3092\u5b9f\u884c\u3057\u307e\u3059<br \/>\n\u3000\u5b9f\u884c\u30ed\u30b0\u3092&#8221;IMPORT.LOG&#8221;\u306b\u6307\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true\">DECLARE\r\nhdnl NUMBER;\r\nBEGIN\r\nhdnl := DBMS_DATAPUMP.open(operation=&gt;'IMPORT', job_mode=&gt;'SCHEMA', remote_link=&gt;null, job_name=&gt;null, version=&gt;'COMPATIBLE');\r\nDBMS_DATAPUMP.ADD_FILE(handle=&gt;hdnl, filename=&gt;'EXPORT.DMP', directory=&gt;'DATA_PUMP_DIR', filetype =&gt; dbms_datapump.ku$_file_type_dump_file);\r\nDBMS_DATAPUMP.ADD_FILE(handle=&gt;hdnl, filename=&gt;'IMPORT.LOG', directory =&gt; 'DATA_PUMP_DIR', filetype =&gt; dbms_datapump.ku$_file_type_log_file);\r\nDBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''\u30b9\u30ad\u30fc\u30de\u540d'')');\r\nDBMS_DATAPUMP.start_job(hdnl);\r\nEND;\r\n\/<\/pre>\n<p>\u30fbData Pump\u306e\u5b9f\u884c\u30ed\u30b0\u3092\u78ba\u8a8d\u3057\u307e\u3059<\/p>\n<pre class=\"lang:default decode:true\">SELECT TEXT FROM TABLE(RDSADMIN.RDS_FILE_UTIL.READ_TEXT_FILE('DATA_PUMP_DIR','IMPORT.LOG'));<\/pre>\n<p>\u3000&#8221;successfully completed&#8221;\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u308c\u3070\u30a4\u30f3\u30dd\u30fc\u30c8\u306f\u6210\u529f\u3057\u3066\u3044\u307e\u3059<\/p>\n<pre class=\"nums:false lang:default decode:true\">TEXT\r\n--------------------------------------------------------------------------------\r\nJob \u30de\u30b9\u30bf\u30fc\u30e6\u30fc\u30b6\u30fc\u540d.\"SYS_IMPORT_SCHEMA_01\" successfully completed at Tue Jun 4 18:23:3\r\n3 2019 elapsed 0 00:03:54<\/pre>\n<p>\u30fb\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3068\u5b9f\u884c\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3057\u307e\u3059<\/p>\n<pre class=\"lang:default decode:true \">exec utl_file.fremove('DATA_PUMP_DIR','EXPORT.DMP');\r\nexec utl_file.fremove('DATA_PUMP_DIR','IMPORT.LOG');<\/pre>\n<h2 class=\"posthl02\">\u304a\u308f\u308a\u306b<\/h2>\n<p>\u4eca\u56de\u306f\u30bf\u30a4\u30df\u30f3\u30b0\u3088\u304f\u65b0\u6a5f\u80fd\u3092\u5229\u7528\u3057\u3001\u30b9\u30e0\u30fc\u30ba\u306b\u79fb\u884c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002\u30af\u30e9\u30a6\u30c9\u754c\u9688\u306f\u6280\u8853\u306e\u9032\u6b69\u304c\u901f\u3044\u306e\u3067\u3001\u6700\u65b0\u6280\u8853\u306e\u30ad\u30e3\u30c3\u30c1\u30a2\u30c3\u30d7\u306f\u975e\u5e38\u306b\u91cd\u8981\u3060\u3068\u6539\u3081\u3066\u611f\u3058\u3055\u305b\u3089\u308c\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u306f\u3058\u3081\u306b AWS\u306b\u76f4\u63a5\u63a5\u7d9a\u3067\u304d\u306a\u3044\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u306eOracle Database\u3092RDS\u306b\u79fb\u884c\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3057\u305f\u3002 \u3053\u306e\u5834\u5408\u3001RDS\u306b\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066Oracle Data Pump\u3067\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u65b9\u6cd5\u304c&hellip;<\/p>\n","protected":false},"author":38,"featured_media":5857,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[12,151],"class_list":["post-5717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aws-cloud","tag-aws","tag-ec2"],"aioseo_notices":[],"gutentor_comment":0,"_links":{"self":[{"href":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-json\/wp\/v2\/posts\/5717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-json\/wp\/v2\/comments?post=5717"}],"version-history":[{"count":103,"href":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-json\/wp\/v2\/posts\/5717\/revisions"}],"predecessor-version":[{"id":6152,"href":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-json\/wp\/v2\/posts\/5717\/revisions\/6152"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-json\/wp\/v2\/media\/5857"}],"wp:attachment":[{"href":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-json\/wp\/v2\/media?parent=5717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-json\/wp\/v2\/categories?post=5717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alb-owned-https-576747877.ap-northeast-1.elb.amazonaws.com\/wp-json\/wp\/v2\/tags?post=5717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}