Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How does Oracle back up and restore DMP databases (import and export DMP)

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

Shulou(Shulou.com)06/02 Report--

1. Oracle import backup file steps:

1. Copy the backup file of the database: 123.DMP to the dpdump folder under the oracle installation directory

For example, my path is: d:\ app\ administrator\ admin\ orcl\ dpdump

Log in to sqlplus in your PLSQL Developer or directly under cmd, and do the following

two。 Create tablespace db123.dbf

Create tablespace db123 datafile'D:\ app\ administrator\ admin\ orcl\ dpdump\ db123.dbf' size 500m

Reuse autoextend on next 10m maxsize unlimited extent management local autoallocate permanent online

Specifies that the initial size of the tablespace is 500m, and that the size of each increase after the tablespace is full is 10m.

3. Create a user

Create user + username + identified by + password + default tablespace + tablespace name

-- user, password specify tablespace

4. Authorize the user

Grant connect,resource,dba to user_name

-- authorize the user to user_name.

Connect and resource are built-in roles of the two systems and are juxtaposed with dba.

DBA: has all privileges, is the highest privilege of the system, and only DBA can create the database structure.

RESOURCE: users with Resource permissions can only create entities, not database structures.

CONNECT: users with Connect permission can only log in to Oracle, cannot create entities, and cannot create database structures.

5.cmd runs the following import statement

-- Import database files

Impdp user_name/pwd@orcl dumpfile=123.DMP log=db123.log

Restore the backup file 123.DMP to the user_name user and create a log file called db123.log named db123

2. Oracle exports backup files:

Expdp user_name/pwd@orcl dumpfile = xxx.dmp

-- exports all objects under the user user_name, specifying that the exported backup file name is xx.dmp. The default location of the exported backup files is in the dpdump folder under the oracle installation directory

Third, how to query how many libraries there are?

Plsql developer or sql plus input

Select name from v$database

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report