Home > Database > Oracle > body text

oracle backup database

王林
Release: 2020-05-12 16:49:41
forward
2818 people have browsed it

oracle backup database

The specific steps are as follows:

Create a backup directory (using a sys account). If the backup directory has already been created, this step can be ignored

create directory db_bak as 'D:\ ECIMS_DB'
Copy after login

oracle backup database

Backup (export) database (in cmd state)

expdp XXX/XXX@XXX schemas=XXX dumpfile=XXX_20181130.dump logfile=XXX_20181130.LOG DIRECTORY=DB_BAK
Copy after login

Syntax:

expdp 用户名/密码@实例名 schemas=用户名 dumpfile=导出dump文件名.dump logfile=导出日志文件名.LOG DIRECTORY=DB_BAK
Copy after login

The above is the detailed content of oracle backup database. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:cnblogs.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!