Inspur DPS-M1产品培训课件.ppt

7.Oraclerac备份和恢复（rman脚本）*准备工作：1.设置数据库为归档模式。2.修改root和oracle用户环境变量，添加exportLD_LIBRARY_PATH=/oracle/product/10.2.0/lib/3.重启K1客户端服务，使环境变量生效[root@db1idps]#cd/usr/Inspur/Inspur-DPS/idps/[root@db1idps]#..tina.sh[root@db1idps]#tina_stop[root@db1idps]#tina_daemon*7.1rman用户创建*7.2rman用户配置*7.3归档创建*7.4归档配置*7.5rman备份脚本[oracle@rac2~]$catrman.shconnecttarget/run{allocatechannelc1typesbt_tapeparms=SBT_LIBRARY=/usr/Inspur/Inspur-DPS/idps/Lib/libtina_rman.so,ENV=(TINA=idps,TINA_HOME=/usr/Inspur/Inspur-DPS/idps,TINA_SERVICE_NAME=idps,TINA_RMAN_CATALOG=catalog,TINA_RMAN_FOLDER=rmanfolder,TINA_RMAN_USER=rman)connectsys/oracle@orcl1;allocatechannelc2typesbt_tapeparms=SBT_LIBRARY=/usr/Inspur/Inspur-DPS/idps/Lib/libtina_rman.so,ENV=(TINA=idps,TINA_HOME=/usr/Inspur/Inspur-DPS/idps,TINA_SERVICE_NAME=idps,TINA_RMAN_CATALOG=catalog,TINA_RMAN_FOLDER=rmanfolder,TINA_RMAN_USER=rman)connectsys/oracle@orcl2;backupdatabase;backuparchivelogall;releasechannelc1;releasechannelc2;}*7.6进行rman备份使用oracle用户运行脚本[oracle@rac2~]$rmancmdfilerman.sh作业管理器查看状态*7.7rman恢复脚本[oracle@rac2~]$catrestore.shconnecttarget/run{allocatechannelc1typesbt_tapeparms=SBT_LIBRARY=/usr/Inspur/Inspur-DPS/idps/Lib/libtina_rman.so,ENV=(TINA=idps,TINA_HOME=/usr/Inspur/Inspur-DPS/idps,TINA_SERVICE_NAME=idps,TINA_RMAN_CATALOG=catalog,TINA_RMAN_FOLDER=rmanfolder,TINA_RMAN_USER=rman)connectsys/oracle@orcl1;allocatechannelc2typesbt_tapeparms=SBT_LIBRARY=/usr/Inspur/Inspur-DPS/idps/Lib/libtina_rman.so,ENV=(TINA=idps,TINA_HOME=/usr/Inspur/Inspur-DPS/idps,TINA_SERVICE_NAME=idps,TINA_RMAN_CATALOG=catalog,TINA_RMAN_FOLDER=rmanfolder,TINA_RMAN_USER=rman)connectsys/oracle@orcl2;restoredatabase;recoverdatabase;releasechannelc1;releasechannelc2;}*7.8进行rman恢复将数据库启动为nomount状态，使用oracle用户运行脚本[oracle@rac2~]$rmancmdfilerecover.sh作业管理器查看状态8.K-DB和db2备份和恢复（包括lanfree模式）*K-DB脚本备份设置*8.1K-DB备份与恢复K-DB备份先将数据库备份到本地，之后与文件备份相同