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!