{"id":6002,"date":"2023-05-10T23:38:43","date_gmt":"2023-05-10T14:38:43","guid":{"rendered":"\/blog\/?p=6002"},"modified":"2023-09-21T09:26:20","modified_gmt":"2023-09-21T00:26:20","slug":"t","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=6002","title":{"rendered":"MySQL\/Oracle\/MS-SQL \ub9ac\ub205\uc2a4\uc6a9 \ubcf5\uc6d0 \uc2a4\ud06c\ub9bd\ud2b8"},"content":{"rendered":"\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">#################################################\n#\n# Oracle DB \ubcf5\uc6d0\n#\n#################################################\nsqlplus \"system\/manager as sysdba\"\n  -- \uc2a4\ud0a4\ub9c8 \ubc0f \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0e5\uc81c\n  -- Oracle 12c\uc758 \uc774\uc804\ubc84\uc804 \ud638\ud658\uc744 \uc704\ud55c \uc124\uc815\n  ALTER SESSION SET \"_ORACLE_SCRIPT\"=TRUE;\n  DROP USER u_ssc_1820 CASCADE;\n  DROP TABLESPACE ts_ssc_1820 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;\n  -- \uc2a4\ud0a4\ub9c8 \ubc0f \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ub2e4\uc2dc \uc0dd\uc131\n  ALTER SESSION SET \"_ORACLE_SCRIPT\"=TRUE;\n  CREATE TABLESPACE ts_ssc_1820 DATAFILE '\/opt\/oracle\/oradata\/ORCLCDB\/ts_ssc_1820.dbf' SIZE 2M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;\n  CREATE USER u_ssc_1820 IDENTIFIED BY \"&lt;PASSWORD>\";\n  ALTER USER u_ssc_1820 DEFAULT TABLESPACE ts_ssc_1820;\n  ALTER USER u_ssc_1820 TEMPORARY TABLESPACE TEMP;\n  GRANT CONNECT, DBA, RESOURCE TO u_ssc_1820;\n# \ubcf5\uc6d0\nsqlplus \"system\/manager as sysdba\"\n  CREATE DIRECTORY DIR_SSC_BACKUP AS '\/work\/db_backup\/oracle';\nimpdp 'u_ssc_1820\/&lt;PASSWORD>@ORCLCDB' SCHEMAS=u_ssc_1820 DIRECTORY=DIR_SSC_BACKUP DUMPFILE=20230509_131353_db_ssc_1820.dmp LOGFILE=20230509_131353_db_ssc_1820.log\nsqlplus \"system\/manager as sysdba\"\n  -- \ud544\uc694\ud55c \uacbd\uc6b0 \ub514\ub809\ud1a0\ub9ac \uc0ad\uc81c\n  DROP DIRECTORY DIR_SSC_BACKUP;\n\n#################################################\n#\n# Microsoft SQL DB \ubcf5\uc6d0\n#\n#################################################\n# DB \uc0ad\uc81c\nsqlcmd -S TCP:10.10.10.105 -U SA -P'&lt;PASSWORD>' -Q \"DROP DATABASE [db_ssc_2020]\"\n# \ubcf5\uc6d0\nsqlcmd -S TCP:10.10.10.105 -U SA -P'&lt;PASSWORD>' -Q \"RESTORE DATABASE [db_ssc_2020] FROM DISK = N'\/work\/db_backup\/mssql\/20230509_131353_db_ssc_2020.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5\"\nsqlcmd -S TCP:10.10.10.105 -U SA -P'&lt;PASSWORD>' -Q \"RESTORE DATABASE [db_ssc_2020] WITH RECOVERY\"\n\n#################################################\n#\n# MySQL \ubcf5\uc6d0\n#\n#################################################\nmysql -u root -p&lt;PASSWORD>\n  -- DB\uc640 \uc0ac\uc6a9\uc790\ub97c \uc0ad\uc81c\ud55c\ub2e4.\n  DROP DATABASE IF EXISTS db_ssc_2222;\n  DROP USER IF EXISTS 'u_ssc'@'localhost';\n  DROP USER IF EXISTS 'u_ssc'@'%';\n  -- DB\uc640 \uc0ac\uc6a9\uc790\ub97c \uc0dd\uc131\ud55c\ub2e4.\n  CREATE DATABASE db_ssc_2222 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin;\n  CREATE USER 'u_ssc'@'localhost' IDENTIFIED BY '&lt;PASSWORD>';\n  CREATE USER 'u_ssc'@'%' IDENTIFIED BY '&lt;PASSWORD>';\n  GRANT ALL PRIVILEGES ON db_ssc_2222.* TO 'u_ssc'@'localhost';\n  GRANT ALL PRIVILEGES ON db_ssc_2222.* TO 'u_ssc'@'%';\n# \ubcf5\uc6d0\nmysql -u root -p&lt;PASSWORD> db_ssc_2222 &lt; \/work\/db_backup\\mysql\\db_ssc_2222.sql<\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-6002","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/6002","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6002"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/6002\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}