数据库初级管理课程-与恢复

数据库备份和恢复说明简要说明备份策略与备份恢复Caché2016，Ensemble2016等各版本。备份策略电子预览、报表服务器中报表文件定期进行备份。备份的恢复备份方法数据备份数据库备自动备份时间间点自动执行计划任务生成备份文件，并保存在指定。同时，Portal[Home]TaskManagerViewTask1ChangeToSrcList是每天中午12:20更改数据库备份列表的任务（更改备份列表为只备份程序库文件app、medsrc、labsrc、sys等，具体见%SYS下DHCBACK.mac中的ChangeToSrcList，可以根据项目具体需要更改）；12BackupSrcDB是每天中午备份程序库文件的任务（21ChangeToFullList是每天凌晨3点更改数据库备份列表的任务（更改备份列表为备份所有的应用库文件，具体见%SYS下DHCBACK.mac中的12 是每天凌晨备份所有应用的库文件的任务（在任务2ChangeToFullList做完之后执行点击任务ChangeToSrcListChangeToFullListRun 路径：[Home][Backup][Backup储空间不足致使cbk文件大小较前日小很多；）手工备份通过teminal端手动执行备份任务指令，生成系统备份文件，并保存到指定，数据备份原理与手工备份相同。数据库冷备份应用文件备份HIS的app文件备份unix、linuxCSP文件，一般是在配置文件备份数据库cpf文件备份类unix操作系统一般在/cachesys下)，文件名：cache.cpf，集成库系统配置备份（请补充恢复方法准备恢复环境shadow服务器，优先使用shadow/mirror服务器做为恢复环境。数据库备份文件恢复到shadow数据将备份文件拷贝到shadow数据库服务器：UnixLinuxrcpftpshadowrcp命令拷贝cbkshadow数据库服务器[root@HisShadow/]#cd/shbackup/backup/[root@HisShadowbackup]#ls-ltotal[root@HisShadowrcp-rp [root@HisShadowbackup]#ls-l-rwxrwxrwx1rootroot12024207360May2803:06 ftp命令拷贝cbkshadow数据库服务器[root@HisShadow/]#ftp37Connectedto37.220his-x4800FTPserver(Version5.60)KerberosV4krb_mk_reqfailed:YouhavenoticketscachedName(37:root):root331Passwordrequiredforroot.230Userrootloggedin.RemotesystemtypeisUNIX.Usingbinarymodetotransferfiles.ftp>cd/backup/backup250CWDcommandsuccessful.ftp>ls-l227EnteringPassiveMode(10,80,99,137,155,80)150OpeningASCIImodedataconnectionfor/bin/ls. -rw-r-----1cacheusr May2812:21 226Transfercomplete.ftp>pwd257"/backup/backup"iscurrentdirectory.ftp>lcd/shbackup/backupLocaldirectorynow/shbackup/backupftp>bin200Typesettoftp>get 226Transfer12024207360bytesreceivedin1e+02seconds(1.1e+05Kbytes/s)ftp>bye[root@HisShadowbackup]#ls-l-rwxrwxrwx1rootroot12024207360May2803:06 将拷贝来的备份文件进行数据恢复[root@HisShadowbackup]#cd/shbackup/backup[root@HisShadowbackup]#ls-l-rwxrwxrwx1rootroot12024207360May2803:06 [root@HisShadowbackup]#cacheNode:HisShadow,Instance:SHCACHEUsername:_systemPassword:***USER>zn%SYS>dRestoreRestoreSelectedorRenamedEdit/DisyListofDirectoriesforAbortOption?Doyouwanttosetswitch10sothatotherprocesseswillbepreventedfromrunningduringtherestore?Yes=>yesSpecifyinputfileforvolume1ofbackup1(TypeSTOPto _001.cbk--注释： ThisbackupvolumewascreatedCacheforUNIX(RedHatEnterpriseLinux5forx86-64)2010.2.8Thevolumelabelcontains:Volume Volumebackup MAY28201403:01AMFullPreviousbackupMAY27201412:21PMFullLastFULLbackupMAY27201412:21PM Fullbackupofalldatabasesthatareinthebackupdatabaselist.Buffer Isthisthebackupyouwanttostartrestoring?Yes=>yesForeachdatabaseincludedinthebackupfile,youcan:--pressRETURNtorestoreittoitsoriginal--typeX,thenpressRETURNtoskipitandnotrestoreitat--typeadifferentdirectoryname.Itwillberestoredtothedirectoryyouspecify.(Ifyouspecifyadirectorythatalreadycontainsadatabase,thedataitcontainswillbelost).*/data/db/dthis/app/=> */data/db/dthis/audit/=>省略N多database*/data/db/dthis/workload/=>/shdata/db/dthis/workloadDoyouwanttochangethislistofdirectories?NoRestorewilloverwritethedataintheolddatabase.ConfirmRestore?***Restoring/data/db/dthis/app/to/shdata/db/dthis/app/at15:38:48375344blocksrestoredin13.6secondsforthispass,375344total省略N多***Restoring/data/db/dthis/workload/to/shdata/db/dthis/workload/at15:39:401blocksrestoredin0.0secondsforthispass,18472totalSpecifyinputfileforvolume1ofbackupfollowingMAY28201403:01AM(TypeSTOPtoexit)Doyouhaveanymorebackupstorestore?Yes=>noMounting 省略N多Mounting Restoringadirectoryrestorestheglobalsinitonlyuptothedateofthebackup.Ifyouhavebeenjournaling,youcanapplyjournalentriestorestoreanychangesthathavebeenmadeintheglobalssincethebackupwasmade.WhatjournalentriesdoyouwishtoAllentriesforthedirectoriesthatyouAllentriesforallSelecteddirectoriesandNoApply:1 RestoreRestoreSelectedorRenamedEdit/DisyListofDirectoriesfor 追加journal日志选择追加journalFullDBList__001.cbk2014-05-2803:01:00以选择下图圈中Timestart后弹出界面，点击选择节点，如下：shadow（比如select*frompa_admorderby2descshadow把生产库上的日志都拷贝到shadow且追加完毕后进行检查）数据库备份文件恢复到mirror数据将备份文件拷贝到mirror数据库服务器：拷贝过程见4.2.1。将拷贝过来的数据进行恢复[root@his_mirrorbackup]#cd/backup[root@his_mirrorbackup]#ls-l-rw-r--r--1rootroot 3月 [root@his_mirrorNode:his_mirror,Instance:

USER>zn%SYS>dRestoreRestoreSelectedorRenamedEdit/DisyListofDirectoriesforAbortDisyBackupvolumeMonitorprogressofbackuporOption?Doyouwanttosetswitch10sothatotherprocesseswillbepreventedfromrunningduringtherestore?Yes=>yesSpecifyinputfileforvolume1ofbackup1(TypeSTOPtoexit)Device:/backup/FullDBList_ ThisbackupvolumewascreatedCacheforUNIX(RedHatEnterpriseLinuxforx86-64)Thevolumelabelcontains:Volumenumber Volume MAR3201704:53PMPreviousbackup FEB14201701:18PMFullLastFULLbackup FEB14201701:18PM databaselist.Buffer Mirrorname FailoverMember Isthisthebackupyouwanttostartrestoring?Yes=>yLimitrestoretomirroreddatabases?nForeachdatabaseincludedinthebackupfile,you--pressRETURNtorestoreittoitsoriginal--typeX,thenpressRETURNtoskipitandnotrestoreitat--typeadifferentdirectoryname.Itwillberestoredtothedirectoryyouspecify.(Ifyouspecifyadirectorythatalreadycontainsadatabase,thedataitcontainswillbelost)./data/db/dthis/app/(:mirror:DHCMIRROR:DHC-APP)=>Thetargetdatabaseisactiveandismoreuptodatethanthecopyinthebackup.Continuingwilloverwritethecontentsof/data/db/dthis/app/witholderdata.Continue?<No>Thetargetdatabaseisactiveandismoreuptodatethanthecopyinthebackup.Continuingwilloverwritethecontentsof/data/db/dthis/audit/witholderdata.Continue?<No>y/data/db/dthis/workload/(:mirror:DHCMIRROR:DHC-Thetargetdatabaseisactiveandismoreuptodatethanthecopyinthebackup.Continuingwilloverwritethecontentsof/data/db/dthis/workload/witholderdata.Continue?<No>yRestorewilloverwritethedataintheolddatabase.ConfirmRestore?=>***Restoring/data/db/dthis/app/at597408blocksrestoredin308.0secondsforthispass,597408total***Restoring/data/db/dthis/audit/at67blocksrestoredin0.0secondsforthispass,67total***Restoring/data/db/dthis/workload/at2blocksrestoredin0.0secondsforthispass,8718totalSpecifyinputfileforvolume1ofbackupfollo