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

二、还原