Oracle10gRAC 每个节点归档仅自己可见
IP 171 173
171 归档备份
173 归档备份+全备份
173 client 客户端安装
#关闭进程
nsr_shutdown
#卸载软件
smitty
LGTOnmo.rte #NetWorker Module for Databases
LGTOnw.clnt.rte #NetWorker Client
LGTOnw.node.rte #光纤线
#卸载选项
PREVIEW only? (remove operation will NOT occur) no +
REMOVE dependent software? yes
#备份之前nmo方式的目录并安装client
mv /nsr /nsr.bakk
gunzip nw76*
tar -xvf nw76sp2_aix.tar 生成aix
cd aix
smitty install
software to install [_all_latest]
LGTOnw.clnt #安装
#生成/nsr 及子目录
rc.nsr start #此动作一定要先于nmda12_aix_64.tar.gz安装
root@fwktdb1:/nsr>ls
applogs cores dedup logs res run tmp
#56 备份master
nsradmin -p nsrexecd 找到fwktdb2 y quit 进程清空
173
gunzip nmda12_aix_64.tar.gz &&tar -xvf nmda12_aix_64.tar
smitty #当前目录下
LGTOnmda #NetWorker Module for Databases
#注意安装生成目录 和没安装数据库模块之前对比
root@fwktdb2:/home>cd /nsr
root@fwktdb2:/nsr>ls
applogs apps cores dedup logs res run tmp
root@fwktdb2:/nsr>cd apps
root@fwktdb2:/nsr/apps>ls
config logs res tmp
root@fwktdb2:/nsr/apps>cd config
root@fwktdb2:/nsr/apps/config>ls
nmda_db2.cfg nmda_informix.cfg nmda_lotus.cfg nmda_oracle.cfg
#创建备份用户冰赋权
create user backup identified by backup;
grant sysdba,connect,resource to backup;
#tnsnames.ora
fwktdb2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 133.224.202.173)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(sid = fwktdb2)
)
)
sqlplus backup/backup@fwktdb2 #successful
#创建库连接
cd $ORACLE_HOME/lib
ls -ll | grep libobk
libobk.a->/usr/lib/libnwora.a
rm -rf libook.a
ln -s /usr/lib/libnsrora.a libobk.a
#更改配置文件
cd /nsr/apps/conifg
vi nmda.oracle.cfg
ORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1
ORACLE_SID=fwktdb2
ORACLE_USER=oracle
NSR_RMAN_ARGUMENTS ="nocatalog target backup/backup@fwktdb2 msglog '/nsr/applogs/oracle.log' append"
TNS_ADMIN =/oracle/app/oracle/product/10.2.0/db_1/network/admin
#备份脚本
root@fwktdb2:/rman_script>more ora_full.sh
run {
allocate channel t1 type 'SBT_TAPE' ;
allocate channel t2 type 'SBT_TAPE' ;
allocate channel t3 type 'SBT_TAPE' ;
allocate channel t4 type 'SBT_TAPE' ;
send 'NSR_ENV=(NSR_SERVER=legato-server-ibm3650,NSR_DATA_VOLUME_POOL=fwktvtl,NSR_CLIENT=fwktdb2)';
backup filesperset 4
format 'FULL_%d_%U'
(database);
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}
root@fwktdb2:/rman_script>more nsrarchivelog
run {
set command id to 'lgto_fwkt_arch2';
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=legato-server-ibm3650,NSR_DATA_VOLUME_POOL=fwktvtl,NSR_CLIENT=fwktdb2)';
backup filesperset 4
format 'fwktdb2_%s_%p'
(archivelog all not backed up delete input skip inaccessible);
release channel t1;
release channel t2;
}
#图形界面设置
存储集 /rman_scritp/ora_full.sh
备份命令nsrdasv -z /nsr/apps/config/nmda_oracle.cfg
0832
rman target / cmdfile="/rman_qcript/nsrarchivelog"
####################3
171上同样配合 但是出现赋权错误解决办法
grant sysdba,connect,resource to backup;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26179376/viewspace-2120927/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26179376/viewspace-2120927/