--首先热机备份是能够边使用边备份,这样如果主机突然坏了,能够切换到备份机上,不是简单的数据泵导入导出操作。具体含义还是百度吧,热备,我也没怎么看。 --数据泵导入操作 SQLPLUS SYSTEM/[email protected]/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
--数据泵导入操作
SQLPLUS SYSTEM/[email protected]/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