使用配置文件自动备份远程oracle数据库

一、编写配置文件quartz.properties，放置在src目录下；

#是备份数据库的url
db_url=192.168.11.201:1521/orcl
#是备份数据库的username
db_username=trems
#是备份数据库的password
db_password=trems
#是备份数据库的实例名
db_dbname=orcl
#备份文件存放路径
backupToPath=C:\\Users\\Administrator\\Desktop

package quartz;import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Properties;
import org.apache.log4j.Logger;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;public class BackupDataBase {private static Logger log = Logger.getLogger(BackupDataBase.class);private static String username;private static String password;private static String backupToPath;private static String url;/*** 读取配置文件*/static {log.debug("开始读取配置文件");InputStream is = null;try {Properties properties = new Properties();Resource resource = new ClassPathResource("/quartz.properties");properties.load(resource.getInputStream());url = (String) properties.get("db_url");username = (String) properties.get("db_username");password = (String) properties.get("db_password");backupToPath = (String) properties.get("backupToPath");log.debug("成功读取配置文件");} catch (FileNotFoundException e) {log.error("读取配置文件失败", e);} catch (IOException e) {log.error("读取配置文件失败", e);} finally {try {if (is != null) {is.close();}log.debug("成功关闭输入流");} catch (IOException e) {log.error("关闭输入流失败", e);}}}/*** 备份数据库*/public static void exportDataBase() {SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");String dbName = sdf.format(new Date()) + ".dmp";try {String command = "exp " + username + "/" + password + "@" + url+ " file=" + backupToPath +"\\" + dbName + " full=y";Runtime.getRuntime().exec(" cmd /c start " + command +"exit");log.debug("备份数据库成功！");} catch (IOException e) {e.printStackTrace();log.error("备份数据库失败！", e);}}public static void main(String[] args) {BackupDataBase demo = new BackupDataBase();demo.exportDataBase();}
}