实验环境:
Oracle Linux 7.9
Oracle DB&GI 11.2.0.4
导出备份:
1.创建导出目录:
[root@rac1 ~]# mkdir /u01/app/dump [root@rac1 ~]# chmod 777 /u01/app/dump [root@rac1 ~]# chown -R oracle:oinstall /u01/app/dump
2.创建导出路径与数据库的连接,并对相关用户进行授权
[oracle@rac1 ~]$ sqlplus / as sysdba SQL> create or replace directory bak_dir as '/u01/app/dump'; Directory created. SQL> grant write,read on directory bak_dir to zw; Grant succeeded.
3.查看监听状态,确认监听打开
[oracle@rac1 ~]$ lsnrctl status
4.导出备份文件到指定路径
[oracle@rac1 ~]$ expdp zw/zw DIRECTORY=BAK_DIR DUMPFILE=zwbak.dmp LOGFILE=exp.log
1.建立导入路径,并授权
建立导入目录: [oracle@rac2 ~]$ sqlplus / as sysdba SQL> create or replace directory IMP_DIR AS '/u01/app/dump'; Directory created. 授权: SQL> GRANT READ, WRITE ON DIRECTORY IMP_DIR TO zw; Grant succeeded.
2.建立相同表空间
SQL> CREATE TABLESPACE mytbs DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 2G EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL> SELECT tablespace_name, file_name FROM dba_data_files WHERE tablespace_name = 'MYTBS'; TABLESPACE_NAME ------------------------------ FILE_NAME -------------------------------------------------------------------------------- MYTBS +DATA/orcl/datafile/mytbs.268.1196663177
为表空间分配用户:
SQL> alter user zw default tablespace mytbs; User altered. SQL> alter user zw quota unlimited on mytbs; User altered.
3.导入备份数据
[oracle@rac2 ~]$ impdp zw/zw DIRECTORY=IMP_DIR DUMPFILE=zwbak.dmp LOGFILE=impdb.log CLUSTER=YES
注意:如果出现报错“Linux-x86_64 Error: 13: Permission denied”,说明导入目录的权限设置有问题,需要切换root用户用chmod/chown修改权限。
|