oracle备份还原

oracle备份还原方式一：

1、以管理员身份登录：
sqlplus sys/admin@localhost:1521/orcl as sysdba;

sqlplus sys/admin@localhost:1521/dzdadb as sysdba;

2、创建目录
create or replace directory bak_path as ‘E:\backup’;

3、退出
exit/quit

4、备份：
expdp ‘sys/sys@localhost:1521/orcl as sysdba’ directory=bak_path dumpfile=gjjhhht-expdp.dmp logfile=gjjhhht.log schemas=gjjhhht

expdp ‘sys/sys@localhost:1521/orcl as sysdba’ directory=bak_path dumpfile=hhhtview-expdp.dmp logfile=hhhtview.log schemas=hhhtview

5、 还原：
impdp ‘sys/sys@localhost:1521/orcl as sysdba’ directory=bak_path dumpfile=gjjhhht-expdp.dmp logfile=gjjhhht.log remap_schema=gjjhhht:gjjhhht exclude=user table_exists_action=replace remap_tablespace=GJJHHHT_DATA:GJJHHHT_DATA

impdp ‘sys/sys@localhost:1521/orcl as sysdba’ directory=bak_path dumpfile=hhhtview-expdp.dmp logfile=hhhtview.log remap_schema=hhhtview:hhhtview exclude=user table_exists_action=replace remap_tablespace=users:users

备份还原方式二：

导入：
–create smallfile tablespace gjjhhhtest1 datafile’D:\temptest’ size 200m autoextend on next 100m maxsize unlimited logging extent management local segment space management auto;
–create user hhhtviewTest identified by gjjhhhtTest default tablespace gjjhhhtest1 temporary tablespace temp;
–grant connect,resource to hhhtviewTest;
–grant create session to hhhtviewTest;
–grant create user,drop user,alter user ,create any view,drop any view,exp_full_database,imp_full_database,dba,connect,resource,create session to gjjhhhtTest;
导入所有的
imp gjjhhhtTest/gjjhhhtTest12@172.16.1.65/orcl full=y file=’d:\20171118.dmp’ ignore=y log=’gjjhhhtest1’
导入用户
imp gjjhhhtTest/gjjhhhtTest12@172.16.1.65/orcl fromuser=gjjhhht file=d:\20171118.dmp
导出所有的：
exp gjjhhht/gjjhhht12@172.16.1.65/orcl file=d:\20171118.dmp full=y
导出用户的：
exp userid=gjjhhht/gjjhhht@172.16.1.65/orcl owner=(gjjhhht) file=d:\20171118.dmp