oracle flows files,Oracle数据库的备份与恢复（expdp与impdp）

oracle 备份请移步至此链接

Oracle数据库还原IMPDP命令是相对于EXPDP命令的，方向是反向的。即对于数据库备份进行还原操作。

Schema模式导入[schema]

此处是还原IDC这个(用户)方案

impdp system/123456 directory=EXPDP_DMP dumpfile=db_backup_190322.dmp schemas=idc  [table_exists_action=replace]

注意：

在操作以上恢复数据的步骤时先须要操作如下：

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 25 06:39:39 2019

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select instance_name from v$instance;               #查询当前数据库实例

INSTANCE_NAME

—————-

testdb

SQL> select username,default_tablespace from dba_users;       #查看用户和密码表空间的关系

USERNAME DEFAULT_TABLESPACE

—————————— ——————————

SYS SYSTEM

SYSTEM SYSTEM

IDC USERS

OUTLN SYSTEM

MGMT_VIEW SYSTEM

FLOWS_FILES SYSAUX

MDSYS SYSAUX

ORDDATA SYSAUX

ORDSYS SYSAUX

ANONYMOUS SYSAUX

EXFSYS SYSAUX

USERNAME DEFAULT_TABLESPACE

—————————— ——————————

DBSNMP SYSAUX

WMSYS SYSAUX

SYSMAN SYSAUX

XDB SYSAUX

APPQOSSYS SYSAUX

ORDPLUGINS SYSAUX

APEX_030200 SYSAUX

SI_INFORMTN_SCHEMA SYSAUX

DIP USERS

APEX_PUBLIC_USER USERS

ORACLE_OCM USERS

USERNAME DEFAULT_TABLESPACE

—————————— ——————————

XS$NULL USERS

23 rows selected.

SQL> select * from dba_directories;          #查询已创建的数据目录

OWNER DIRECTORY_NAME

—————————— ——————————

DIRECTORY_PATH

——————————————————————————–

SYS ORACLE_OCM_CONFIG_DIR

/home/oracle/app/oracle/product/11.2.0/dbhome_1/ccr/state

SYS DATA_PUMP_DIR

/home/oracle/app/admin/testdb/dpdump/

SYS XMLDIR

/home/oracle/app/oracle/product/11.2.0/dbhome_1/rdbms/xml

SQL> create directory expdp_dmp as ‘/home/oracle/oracledb_backup’;       #创建数据目录(数据文件存放目录)

Directory created.

SQL> create user idc identified by “123456” account unlock;                    #创建用户并设置非锁定状态

User created.

SQL> grant exp_full_database to idc;                                           #授权用户可导出所有数据库权限

Grant succeeded.

SQL> grant resource to idc;                                                          #授权用户可resource数据权限

Grant succeeded.

SQL> grant imp_full_database to idc;                                      #授权用户可导入所有数据权限

Grant succeeded.

SQL> select name from v$datafile;                                          #查看命名空间文件

NAME

——————————————————————————–

/home/oracle/app/oradata/testdb/system01.dbf

/home/oracle/app/oradata/testdb/sysaux01.dbf

/home/oracle/app/oradata/testdb/undotbs01.dbf

/home/oracle/app/oradata/testdb/users01.dbf

SQL> CREATE TABLESPACE TEST_IDC_DATA DATAFILE ‘/home/oracle/app/oradata/testdb/TEST_IDC_DATA01.dbf’ SIZE 4G AUTOEXTEND ON;       #创建表命名空间

Tablespace created.

SQL> CREATE TABLESPACE TEST_IDC_INDEX DATAFILE ‘/home/oracle/app/oradata/testdb/TEST_IDC_INDEX01.dbf’ SIZE 4G AUTOEXTEND ON;   #创建表命名空间

Tablespace created.

SQL> CREATE TABLESPACE TEST_IDC_FILE DATAFILE ‘/home/oracle/app/oradata/testdb/TEST_IDC_FILE01.dbf’ SIZE 1G AUTOEXTEND ON;           #创建表命名空间

Tablespace created.