300字范文,内容丰富有趣,生活中的好帮手!
300字范文 > NBU 配置ORACLE备份

NBU 配置ORACLE备份

时间:2018-12-27 02:54:11

相关推荐

NBU 配置ORACLE备份

NBU 配置ORACLE备份

安装NBU客户端配置Netbackup创建备份脚本编辑备份脚本备份脚本需要替换的内容创建策略脚本赋权

安装NBU客户端

./install

配置Netbackup

#su – oracle#cd /usr/openv/netbackup/bin/#./oracle_linkTue Mar 13 09:54:51 CST All Oracle instances should be shutdown before running this script.Please log into the Unix system as the Oracle owner for running this scriptDo you want to continue? (y/n) [n] yLIBOBK path: /usr/openv/netbackup/binORACLE_HOME: /oracle/app/oracle/product/11.2.0/db_1Oracle version: 11.2.0.4.0Platform type: x86_64Linking LIBOBK:Moving libobk.so to libobk.so.backln -s /usr/openv/netbackup/bin/libobk.so64 /oracle/XXXXXXX/lib/libobk.soDonePlease check the trace file located in /tmp/make_trace.11011 to make sure the linking process was successful.

创建备份脚本

#mkdir /usr/openv/netbackup/scripts#cd /usr/openv/netbackup/#chmod –R 777 scripts#cd scripts#cp /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/hot_database_backup.sh ./(或是从现在已经在备份的数据库客户端上FTP脚本到新客户端上)

编辑备份脚本

#vi hot_database_backup.sh

备份脚本需要替换的内容

ORACLE_HOME=/db/oracle/product/ora102ORACLE_SID=ora102ORACLE_USER=ora102$RMAN target $TARGET_CONNECT_STR nocatalog msglog $RMAN_LOG_FILE append << EOFRUN {ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';SEND'NB_ORA_POLICY=oracle11g04-database-ora_full,NB_ORA_CLIENT=oracle11g04'; //使用实际的数据库备份策略名称和客户端名称BACKUP$BACKUP_TYPESKIP INACCESSIBLETAG hot_db_bk_level0FILESPERSET 20# recommended formatFORMAT 'bk_%s_%p_%t'DATABASE;sql 'alter system archive log current';RELEASE CHANNEL ch00;RELEASE CHANNEL ch01;# backup all archive logsALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';SEND'NB_ORA_POLICY=oracle11g04-database-ora_arch,NB_ORA_CLIENT=oracle11g04'; //使用实际的归档备份策略名称和客户端名称BACKUPfilesperset 20FORMAT 'al_%s_%p_%t'ARCHIVELOG ALL skip inaccessible DELETE INPUT; //备份完归档后删除RELEASE CHANNEL ch00;RELEASE CHANNEL ch01;

创建策略

在NETBACKUP ADMINISTRATOR CONSOLE里新建策略,注意策略名称使用脚本里指定的名称,以及在TAB (BACKUP SELECTION)里指定脚本的绝对路径:

脚本赋权

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。