记一次oracle数据库备份恢复(linux to win)_linux 下 oracle 数据库文件可以拿到 window 下恢复么-优快云博客

本文链接：https://blog.youkuaiyun.com/gengyaocool/article/details/133778292

本文介绍了在Oracle环境中备份数据库（使用expdp）的过程，包括创建新用户和表空间，以及如何导入DMP文件（impdp）进行数据迁移。详细步骤包括设置目录、创建用户权限和表空间配置等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. su - oracle 备份数据库

expdp system/password directory=DATA_PUMP_DIR dumpfile=2022031101.DMP logfile=2022031101.log schemas=ecology

2.登录win系统

创建新数据库系统，创建用户user ecology 并赋予权限

CREATE USER ecology IDENTIFIED BY password;
GRANT DBA TO ecology;

3.查询原表的表空间，并在win中创建表空间

SELECT tablespace_name, file_name, ROUND(bytes / 1024 / 1024 / 1024, 2) AS size_gb
FROM dba_data_files;

USERS   /u01/app/oradata/oadb/users01.dbf   0
UNDOTBS1   /u01/app/oradata/oadb/undotbs01.dbf   14.71
SYSAUX   /u01/app/oradata/oadb/sysaux01.dbf   27.76
SYSTEM   /u01/app/oradata/oadb/system01.dbf   4.73
ECOLOGY   /u01/app/oradata/oadb/ecology.dbf   32
ECOLOGY   /u01/app/oradata/oadb/ecology_01.dbf   20
ECOLOGY   /u01/app/oradata/oadb/ecology_02.dbf   20
ECOLOGY   /u01/app/oradata/oadb/ecology_03.dbf   2
ECOLOGY   /u01/app/oradata/oadb/ecology_04.dbf   20
ECOLOGY   /u01/app/oradata/oadb/ecology_05.dbf   20
ECOLOGY   /u01/app/oradata/oadb/ecology_06.dbf   11
ECOLOGY   /u01/app/oradata/oadb/ecology_07.dbf   11
ECOLOGY   /u01/app/oradata/oadb/ecology_08.dbf   12.5
SYSTEM   /u01/app/oradata/oadb/system02.dbf   3
SYSAUX   /u01/app/oradata/oadb/sysaux02.dbf   3.5

CREATE TABLESPACE ECOLOGY DATAFILE 'D:\app\Administrator\oradata\oadbtest\ecology.dbf' SIZE 32G ,
                                'D:\app\Administrator\oradata\oadbtest\ecology_01.dbf' SIZE 20G AUTOEXTEND ON MAXSIZE UNLIMITED,
                                'D:\app\Administrator\oradata\oadbtest\ecology_02.dbf' SIZE 20G AUTOEXTEND ON MAXSIZE UNLIMITED,
                                'D:\app\Administrator\oradata\oadbtest\ecology_03.dbf' SIZE 20G AUTOEXTEND ON MAXSIZE UNLIMITED,
                                'D:\app\Administrator\oradata\oadbtest\ecology_04.dbf' SIZE 20G AUTOEXTEND ON MAXSIZE UNLIMITED,
                                'D:\app\Administrator\oradata\oadbtest\ecology_05.dbf' SIZE 20G AUTOEXTEND ON MAXSIZE UNLIMITED,
                                'D:\app\Administrator\oradata\oadbtest\ecology_06.dbf' SIZE 10G AUTOEXTEND ON MAXSIZE UNLIMITED,
                                'D:\app\Administrator\oradata\oadbtest\ecology_07.dbf' SIZE 10G AUTOEXTEND ON MAXSIZE UNLIMITED,
                                'D:\app\Administrator\oradata\oadbtest\ecology_08.dbf' SIZE 10G AUTOEXTEND ON MAXSIZE UNLIMITED;

4.导入dmp文件，cmd运行

impdp system/passwodr directory=DATA_PUMP_DIR dumpfile=20230804.dmp logfile=import20230804.log