{"id":11476,"date":"2016-05-18T13:59:42","date_gmt":"2016-05-18T18:59:42","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=11476"},"modified":"2016-05-18T13:59:42","modified_gmt":"2016-05-18T18:59:42","slug":"bash-example-backup-multiple-oracle-user-schema","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=11476","title":{"rendered":"Bash Example: Backup Multiple Oracle User Schema"},"content":{"rendered":"
\n

Contents<\/h2>\n
    \n\t
  1. \n\t\tExample<\/a>\n\t<\/li>\n\t
  2. \n\t\tReferences<\/a>\n\t<\/li>\n\t
  3. \n\t\t<\/a>\n\t\t
      \n\t\t\t
    1. \n\t\t\t\t<\/a>\n\t\t\t<\/li>\n<\/ol>\n<\/ol>\n<\/ol>\n<\/div>\n
       <\/div>\n

      Example<\/h2><\/span>\n
      \r\n#!\/bin\/sh\r\n\r\nbackup_dir=\/backup\/db\r\ndb_sid=orcl\r\n\r\ndeclare -A usrs\r\nusrs[scott]=tiger\r\nusrs[hr]=hr\r\n\r\ncurr_ts=`date +\"%m-%d-%y_%H-%M-%S\"`\r\ncurr_backup_dir=${backup_dir}\/${curr_ts}\r\nmkdir -p ${curr_backup_dir}\r\n\r\nfor k in \"${!usrs[@]}\"\r\ndo\r\n\techo \"Backing up ${k}...\"\r\n\texpcmd=\"exp ${k}\/${usrs[$k]}@${db_sid} owner=${k} grants=y rows=y compress=y file=${curr_backup_dir}\/${k}.exp log=${curr_backup_dir}\/${k}.log &\"\r\n\techo \"export command is: ${expcmd}\"\r\n\techo \"done.\"\r\n\techo \"\"\r\ndone\r\n\r\necho \"All done.\"\r\n\r\n<\/pre>\n
      References<\/h2><\/span>\n
      * Bash Associative Arrays<\/a><\/p>\n
      <\/h2><\/span>\n
      <\/h3><\/span>\n
      <\/h6><\/span>\n
      \r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
      Example #!\/bin\/sh backup_dir=\/backup\/db db_sid=orcl declare -A usrs usrs[scott]=tiger usrs[hr]=hr curr_ts=`date +”%m-%d-%y_%H-%M-%S”` curr_backup_dir=${backup_dir}\/${curr_ts} mkdir -p ${curr_backup_dir} for k in “${!usrs[@]}” do echo “Backing up ${k}…” expcmd=”exp ${k}\/${usrs[$k]}@${db_sid} owner=${k} grants=y rows=y compress=y file=${curr_backup_dir}\/${k}.exp log=${curr_backup_dir}\/${k}.log &” echo “export command is: ${expcmd}” echo “done.” … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[35,65],"tags":[702,158,507,226,567],"class_list":["post-11476","post","type-post","status-publish","format-standard","hentry","category-oracle","category-shell","tag-array","tag-backup","tag-bash","tag-example","tag-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-2Z6","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/11476","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11476"}],"version-history":[{"count":1,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/11476\/revisions"}],"predecessor-version":[{"id":11477,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/11476\/revisions\/11477"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11476"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11476"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}