环境介绍:
数据库版本:oracle11g
数据库用户名密码:ams/ams
备份文件名称:ams20210315.dmp
导出数据库:
切换用户:su - root
创建备份目录(目录根据自己实际情况):mkdir /opt/yqsh/databak/oracle/bakams/
授权:chown -R oracle:oinstall /opt/yqsh/databak/oracle/bakams/
切换到oracle用户:su - oracle:
sqlplus /nolog
SQL>conn sys/oracle as sysdba;
SQL>create directory bakams as '/opt/yqsh/databak/oracle/bakams'; --可不执行
SQL>grant read on directory bakams to ams;
SQL>grant write on d