windows 下oracle的备份 还原命令

--hreas备份说明
--cmd执行进入sql
sqlplus system/kingdee@hreas as sysdba
--创建备份目录(dmp为变量),sql执行，并给予权限
create or replace directory dmp as 'D:\backup\hreas\'
grant read, write on directory dmp to kingdee;
-----------------------------------------------------------------
以上步骤之需要在第一次时执行，后面不需要执行

--以下为bat文件脚步，直接执行bat文件即可
@echo.服务启动备份......
@echo off 
@REM 开始执行备份
@set BACKUPDATE=%date:~0,4%%date:~5,2%%date:~8,2%
@expdp kingdee/000000@hreas directory=dmp dumpfile=KINGDEEhreas%BACKUPDATE%.DMP logfile=KINGDEEhreas%BACKUPDATE%.log schemas=kingdee
@echo.
@echo.备份完毕！ 

--orcl备份说明
--cmd执行进入sql
sqlplus system/kingdee@orcl as sysdba
--创建备份目录(dmp为变量),sql执行，并给予权限
create or replace directory dmp as 'D:\backup\orcl\'
grant read, write on directory dmp to kingdee;
-----------------------------------------------------------------

--orcl备份说明
--cmd执行进入sql
sqlplus system/kingdee@orcl as sysdba    ---kingdee是用户名   密码也是kingdee    oracl是实例名
                                                                    ----创建备份目录(dmp为变量),sql执行，并给予权限
create or replace directory dmp as 'D:\backup\orcl\'
grant read, write on directory dmp to kingdee;
---------------------------------------------------------------------------------------------------------------------------------
以上步骤之需要在第一次时执行，后面不需要执行
--以下为bat文件脚步，直接执行bat文件即可
@echo.服务启动备份......
@echo off 
@REM 开始执行备份
@set BACKUPDATE=%date:~0,4%%date:~5,2%%date:~8,2%
@expdp kingdee/kingdee@KDDB1 directory=dmp dumpfile=KINGDEEKDDB1%BACKUPDATE%.DMP logfile=KINGDEEKDDB1%BACKUPDATE%.log schemas=kingdee
@echo 备份完毕！
@echo 删除7天前的备份
forfiles /p "D:\backup\KDDB1" /m *.dmp /d -7 /c "cmd /c del @path" 
forfiles /p "D:\backup\KDDB1" /m *.log /d -7 /c "cmd /c del @path" 
exit

注意事项：D:\backup\orcl 该目录需要自己先手工在盘符下手工创建     orcl实例不同 这个不要照抄

 
 

---------------------------------------------------------------------------------------------------------------------------------

EAS_D_EAS_INDEX EAS_D_EAS_STANDARD
1、安装oracle11g
 1）、安装前需先安装.net3.5 (在应用服务管理中添加.net3.5安装)
 2)、安装完成后监听需要删除，然后把网络删除，然后新增
2、sqlplus system/kingdee@orcl as sysdba

drop tablespace EAS_D_KINGDEE_INDEX including contents and datafiles;
drop tablespace EAS_D_KINGDEE_STANDARD including contents and datafiles;
drop tablespace EAS_D_KINGDEE_TEMP2 including contents and datafiles;
drop user kingdee cascade;
--创建表空间与用户，单引号里面的文件名与表空间名字相同

CREATE TABLESPACE EAS_D_KINGDEE_INDEX  DATAFILE 'D:\app\oradata\orcl\EAS_D_KINGDEE_INDEX.ora' SIZE 2000M AUTOEXTEND ON NEXT 200M;
CREATE TABLESPACE EAS_D_KINGDEE_STANDARD DATAFILE 'D:\app\oradata\orcl\EAS_D_KINGDEE_STANDARD.dbf' SIZE 2000M AUTOEXTEND ON NEXT 200M;
CREATE TABLESPACE EAS_D_KINGDEE_TEMP2  DATAFILE 'D:\app\oradata\orcl\EAS_D_KINGDEE_TEMP2.dbf' SIZE 2000M AUTOEXTEND ON NEXT 200M;

--TEMPORARY

--创建用户

create user kingdee identified by 000000 default tablespace EAS_D_KINGDEE_STANDARD;

--给用户授权
grant connect,dba,resource to kingdee;
grant create type to kingdee;
--grant connect to kingdee; 
--grant resource to kingdee; 
--grant dba to kingdee;

--(D:\app\oradata\orcl 为存放恢复文件目录)
create or replace directory DIRFILE_zy as 'D:\app\oradata\orcl';  

--给用户授权
--grant read,write on directory data to kingdee;
grant read,write on directory DIRFILE_zy to kingdee;

--cmd执行恢复

恢复方式 1

impdp kingdee/000000@orcl directory=DIRFILE_zy dumpfile=KINGDEE2021-04-21.DMP logfile=KINGDEE2021-04-21.log remap_schema =kingdee:kingdee

恢复方式 2

impdp kingdee/000000@orcl directory=DIRFILE_zy   dumpfile=KINGDEEKDDB120221120.DMP logfile=KINGDEEKDDB120221120.log cluster=N

---------------------------------------------------------------------------------------------------------------------------------

--备份orcl实例数据
sqlplus system/Orcl2012@orcl as sysdba
----备份数据库
create or replace directory DIRFILE_zy as 'D:\app\oradata';
--授权
grant read, write on directory DIRFILE_zy to kingdee;
--备份
expdp kingdee/orcl@orcl directory=DIRFILE_zy dumpfile=KINGDEEorcl2021-04-21.DMP logfile=KINGDEEorcl2021-04-21.log schemas=kingdee