oracle备份及还原

一、备份

1、不带日期的备份

@echo this is v7hqs database back sourct
exp v7hqs/63015588@V7HQS_MAIN file=E:oracle_bakv7hqsv7hqs.dmp log=E:oracle_bakv7hqsv7hqs.log

2、带日期的备份(自动覆盖)

@echo this is v7hqs database back sourct
exp v7hqs/63015588@V7HQS_MAIN file=E:oracle_bakv7hqsv7hqs%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=E:oracle_bakv7hqsv7hqs%date:~0,4%%date:~5,2%%date:~8,2%.log

二、还原

原文地址:https://www.cnblogs.com/Jian-Zhang/p/8579427.html