PI数据库的备份和恢复

,Click to edit Master title style,Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,Copyright 2008 OSIsoft,Inc.,*,8,.0 PI Server,备份和恢复,8,.1 PI Server,备份,PI Server Daily Backup,最好每天都备份数据,PIBackup.bat,备份最好转移到外部存储介质以避免硬件故障（例如硬盘损坏）,.piadmpisitebackup.bat,3,执行,PI Server,备份,Use the,pibackup.bat,script from the,piadm,folder to launch a PI server backup,Syntax,:pibackup.bat number of archives archive cutoff date,Example,:pibackup.bat E:PIBackup 2*-60d,4,5,备份时用到的参数,如果没有指定,number of archives,and,archive cutoff date,backup subsystem,会使用默认值,Backup_NumArchive(Default:3),Backup_ArchiveCutoffDate(Default:None),Example backup tuning parameters,（默认值）,:,pibackup.bat E:PIBackup,用,Windows,的计划任务自动备份,用,install,开关把,pibackup.bat,脚本加入到,Windows,计划任务,默认计划任务在每天,3:15 AM,Example,:pibackup.bat E:PIBackup-install,6,7,备份目录的结构和内容,adm,:site specific files,pisrvsitestart.bat,pisrvsitestop.bat,pisitestart.bat,pisitebackup.bat,pintbackup.bat,pibackup_3.4.370.bat,arc,:archive and annotation files,bin,:pipeschd.bat,dat,:files from PIdat except archive and annotation files,log,:files from PIlog,PI backup log files,指定点备份,pisitebackup.bat,将备份文件转移,8,pibackup.bat,pisitebackup.bat,9,Backup Complete,怎样知道,Backup,是否成功,?,会有一个,log,文件,Ex.:pibackup_2-Oct-06_03.15.02.txt,PI Server Message Logs,10,备份的故障诊断,在以下位置能够看到备份执行的一些细节：,Backup Script Log,PI Message Log,NT Event Log,piartool command,VSSADMIN,11,手动,备份,手动备份方式：,在,PI-SMT,中直接进行备份。,使用,pibackup,命令进行备份。,停止,PI,数据库，进行冷态全备份。,12,Exercise 8,PI Server Backup,Objective:,Learn how to use and configure the PI Server daily backup,8.2 PI Server,恢复,14,单个归档文件恢复,拷贝备份档案文档,在,PI SMT Archives plug-in,里,Register,档案文件,恢复时版本一致。,15,整个,PI,数据库恢复,重新安装一个空的,PI,数据库。,将备份文件全部覆盖安装目录下的文件夹。,使用,pidiag ar,注册首文档。,启动,PI,数据库，然后注册其它历史文档。,检查,PI,数据库的运行状态和历史数据完整性。,Questions,16,