oracle Database 11g备份还原

一、按下边步骤运行

创建表空间、用户及授权

1、打开cmd用语句链接数据库
sqlplus /nolog
conn / as sysdba


创建新表空间及用户：
CREATE SMALLFILE TABLESPACE "V3XSPACE" DATAFILE 'D:\app\admin\oradata\V3XSPACE.DBF' SIZE 1024M AUTOEXTEND ON NEXT 200M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

 CREATE USER "V3X" PROFILE "DEFAULT" IDENTIFIED BY "Hello01" DEFAULT TABLESPACE "V3XSPACE" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;

用户已创建。

SQL>
SQL> GRANT CREATE VIEW,ALTER SESSION,CONNECT,RESOURCE TO V3X;

授权成功。

SQL> GRANT DBA TO V3X;

授权成功。

SQL> create or replace directory dumpdir as 'D:\app\admin\oradata\orcl\dpdump';

目录已创建。

SQL> grant read,write on directory dumpdir to V3X;

授权成功。



授权成功。


SQL> quit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开

C:\Users\software>impdp V3X/Hello01 @ORCL DIRECTORY=dumpdir DUMPFILE= 202001201155.DMP logfile=318.log