linux oracle 常用命令

#-----------------------------------------------<br />#登入開發機<br />#-----------------------------------------------<br />ssh oa@192.168.1.9<br />#資料庫匯出<br />export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK<br />export f1=`date +%Y%m%d%H%M`.dmp<br />expdp /'sys/pwd@orcl as sysdba/' directory=DATA_PUMP_DIR dumpfile=$f1 schemas=hs_aws_sa3 reuse_dumpfiles=true<br />#複製到dump 到 hs-db<br />scp /home/oa/oracle/admin/orcl/dpdump/$f1 oa@192.168.1.13:/home/oracle/admin/hsoa/dpdump/imp.dmp<br />#登出開發機 Ctrl + D<br />#-----------------------------------------------<br />#登入 hs-web<br />#-----------------------------------------------<br />ssh oa@192.168.1.14<br /># 備份 plugs<br />tar -czvf /home/backup/plugs_`date +%Y%m%d%H%M`.tgz /home/hs_aws_system/bin/plugs/<br /># 複製 plugs java 包 到 hs-web<br />scp -r oa@192.168.1.9:/home/oa/hs_aws_system/bin/plugs /home/hs_aws_system/bin/plugs<br />#備份表單<br />tar -czvf /home/backup/eform_html`date +%Y%m%d%H%M`_bak.tgz /home/hs_aws_system/template/eform/html<br /># 複製 表單 到 hs-web<br />scp -r oa@192.168.1.9:/home/oa/hs_aws_system/template/eform/html /home/hs_aws_system/template/eform/html<br />#登出hs-web Ctrl + D<br />#-------------------------------------------------<br />#登入 hs-db<br />#------------------------------------------------<br />ssh oa@192.168.1.13<br />#備份<br />export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK<br />export f2=exp_`date +%Y%m%d%H%M`.bak<br />expdp /'sys/pwd@hsoa as sysdba/' directory=DATA_PUMP_DIR dumpfile=$f2 schemas=hs_aws_sa reuse_dumpfiles=true<br />mv /home/oracle/admin/hsoa/dpdump/$f2 /home/oracle/backup/<br />#sqlplus 登入資料庫<br />sqlplus sys/pwd@hsoa as sysdba<br />#刪除資料表空間<br />Drop TableSpace hs_aws_ts including contents and datafiles;<br />#建立資料表空間<br />CREATE SMALLFILE TABLESPACE "HS_AWS_TS" DATAFILE '/home/oracle/oradata/hsoa/hs_aws_ts.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE 32767M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;<br />#匯入<br />export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK<br />impdp /'sys/pwd@hsoa as sysdba/' directory=DATA_PUMP_DIR dumpfile=imp.dmp schemas=hs_aws_sa3 REMAP_SCHEMA=hs_aws_sa3:hs_aws_sa<br /> 

 

dbca 命令 ：管理 oracle 執行個體 .

刪除 oracle 執行個體,通過刪相應安裝目錄,還應刪 /etc/oratab 檔案，每個安裝執行個體都會在這個檔案裡記錄的。