oracle备份及还原

一、备份

1、不带日期的备份

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

2、带日期的备份（自动覆盖）

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

二、还原

转载于:https://www.cnblogs.com/Jian-Zhang/p/8579427.html