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'

Backup (export) database (in cmd state)

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

Syntax:

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

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