1.生产环境的数据每天备份,然后异地备份到测试环境
1)创建测试环境存储数据的文件件,以ftpfile为例,共享该文件夹;
2)在生产环境映射到该文件夹 \\测试ip\ftpfile,创建好会出现相应的盘符Z;
3)创建一个备份和拷贝的bat文件,放到c盘
备份exp hsta/hsta@orcl file=D:\backup\hsta_backup_%date:~0,4%%date:~5,2%%date:~8,2%.dmp full=y
拷贝xcopy d:\backup\*.* z:\/s/h/d/y (把d盘backup下的文件,拷贝到Z盘,这个拷贝是增量的。可以d:\backup\*.dmp,只拷贝dmp文件)
4)创建每天的
计划
项目进度计划表范例计划下载计划下载计划下载课程教学计划下载
任务,按下图顺序,然后确定。
2.生产环境的数据每天备份,然后异地备份到测试环境,并且把数据恢复到测试环境
1)计划任务同上,在测试环境做,bat文件是把估值生产环境的数据先备份到测试,然后删除测试用户和
表
关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf
空间,然后创建测试表空间和用户,再导入从生产导出的数据的过程
@Echo off
SET FA=FA
SET FA_CS=FA_CS
SET USER=hsfa
SET USER_CS=sys
SET PWD=hsfa_0601
SET PWD_CS=oracle
SET SID=hsfa
SET SID_CS=hsfapdb_cs
SET EXPDATE=%date:~0,10%
SET BAK=%FA%_%EXPDATE%.dmp
SET LOG=%FA%_%EXPDATE%.log
SET LOG_CS=%FA_CS%_%EXPDATE%.log
SET DATAPATH=D:\gzzjqs\backup
exp %USER%/%PWD%@%SID% FILE="%DATAPATH%\%BAK%" log="%DATAPATH%\%LOG%" RECORDLENGTH=65535 DIRECT=Y
sqlplus %USER_CS%/%PWD_CS%@%SID_CS% as sysdba @D:\gzzjqs\FA_BAK\recover.sql
imp %USER%/%PWD%@%SID_CS% FILE="%DATAPATH%\%BAK%" log="%DATAPATH%\%LOG_CS%" fromuser=hsfa touser=hsfa
【recover.sql是:
drop user hsfa cascade;
Create user hsfa Identified by hsfa_0601
Default tablespace tbs_hsfa
Temporary tablespace temp;
Grant connect,resource to hsfa;
Grant create table,create view to hsfa;
Grant debug connect session to hsfa;
Grant dba to hsfa;
revoke unlimited tablespace from hsfa;
alter user hsfa quota unlimited on tbs_hsfa;
exit;
】
3.扩展
=================================================================================
forfiles /p E:\backup /m *.dmp /d -5 /c "cmd /c echo deleting @file ... && del /f @path"-------删除E盘backup文件夹下5天前的dmp文件
=================================================================================
xcopy E:\backup\*.dmp z:\/s/h/d/y-------------拷贝
=================================================================================
删除在C盘backup目录下最后修改日期在10天前的文件
=================================================================================
forfiles /p "c:\backup" /d -10 /c "cmd /c echo deleting @file ... &&del /f @path"
=================================================================================
复制当前日期的文件
echo %date%
setnian=%date:~0,4%
setyue=%date:~5,2%
setri=%date:~8,2%
xcopy c:\1\*.* d:\2\/s/e/d:%yue%-%ri%-%nian%/y