PI数据库的备份和恢复.ppt

8.0PIServer备份和恢复,8.1PIServer备份,PIServerDailyBackup,最好每天都备份数据PIBackup.bat备份最好转移到外部存储介质以避免硬件故障（例如硬盘损坏）.piadmpisitebackup.bat,3,执行PIServer备份,Usethepibackup.batscriptfromthepiadmfoldertolaunchaPIserverbackupSyntax:pibackup.batnumberofarchivesarchivecutoffdateExample:pibackup.batE:PIBackup2*-60d,4,5,备份时用到的参数,如果没有指定numberofarchivesandarchivecutoffdate,backupsubsystem会使用默认值Backup_NumArchive(Default:3)Backup_ArchiveCutoffDate(Default:None)Examplebackuptuningparameters（默认值）:pibackup.batE:PIBackup,用Windows的计划任务自动备份,用install开关把pibackup.bat脚本加入到Windows计划任务默认计划任务在每天3:15AMExample:pibackup.batE:PIBackup-install,6,7,备份目录的结构和内容,adm:sitespecificfilespisrvsitestart.bat,pisrvsitestop.bat,pisitestart.bat,pisitebackup.bat,pintbackup.bat,pibackup_3.4.370.batarc:archiveandannotationfilesbin:pipeschd.batdat:filesfromPIdatexceptarchiveandannotationfileslog:filesfromPIlogPIbackuplogfiles,指定点备份pisitebackup.bat,将备份文件转移,8,pibackup.bat,pisitebackup.bat,2019/12/12,9,可编辑,10,BackupComplete,怎样知道Backup是否成功?会有一个log文件Ex.:pibackup_2-Oct-06_03.15.02.txtPIServerMessageLogs,11,备份的故障诊断,在以下位置能够看到备份执行的一些细节：,BackupScriptLogPIMessageLogNTEventLogpiartoolcommandVSSADMIN,12,手动备份,手动备份方式：,在PI-SMT中直接进行备份。使用pibackup命令进行备份。停止PI数据库，进行冷态全备份。,13,Exercise8,PIServerBackupObjective:LearnhowtouseandconfigurethePIServerdailybackup,8.2PIServer恢复,15,单个归档文件恢复,拷贝备份档案文档在PISMTArchivesplug-in里Register档案文件恢复时版本一致。,16,整个PI数据库恢复,重新安装一个空的PI数据库。将备份文件全部覆盖安装目录下的文件夹。使用pidiagar注册首