--首先热机备份是能够边使用边备份,这样如果主机突然坏了,能够切换到备份机上,不是简单的数据泵导入导出操作。具体含义还是百度吧,热备,我也没怎么看。
--数据泵导入操作
SQLPLUS SYSTEM/123456@127.0.0.1/ORCLPC
CREATE TABLESPACE "ORCL" DATAFILE 'D:\oracleData\ORCL.dbf' SIZE 30M REUSE AUTOEXTEND ON NEXT 64M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE USER "ORCL" PROFILE "DEFAULT" IDENTIFIED BY "xpar" DEFAULT TABLESPACE "ORCL"
TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT UNLIMITED TABLESPACE TO "ORCL";
GRANT "DBA" TO "ORCL";
create or replace directory impdp_dir as 'D:\xir_database_2018-01-24';
grant read, write on directory impdp_dir to ORCL;
exit;
impdp ORCL/123456@ORCLPC directory=impdp_dir schemas=ORCL dumpfile=ORCL_2018-01-24.DMP logfile=ORCL_2018-01-30.log