app比网站的优势,wordpress数据库导入,检查网站收录问题,wordpress删主题客户需求对oracle数据库做一个跨机房的备份#xff0c;原环境已做rman备份和每天expdp全库导出#xff0c;远端只有虚拟化环境#xff0c;可提供一个虚拟机#xff0c;2个机房间网络互通。
首先配置nfs服务端
查看操作系统版本
[rootnas199 ~]# more /etc/redhat-relea…客户需求对oracle数据库做一个跨机房的备份原环境已做rman备份和每天expdp全库导出远端只有虚拟化环境可提供一个虚拟机2个机房间网络互通。
首先配置nfs服务端
查看操作系统版本
[rootnas199 ~]# more /etc/redhat-release CentOS Linux release 7.9.2009 (Core)
yum包
[rootnas199 ~]# yum -y install nfs-server portmap showmount
把NFS设为开机自启 [rootnas199 ~]# systemctl enable nfs systemctl start nfs 将RPC设为开机自启 [rootnas199 ~]# systemctl enable rpcbind systemctl start rpcbind 关闭防火墙 [rootnas199 ~]# systemctl stop firewalld systemctl disable firewalld
查看数据库的oracle用户id和组id
[rootdb1 ~]# id oracle uid54321(oracle) gid54321(oinstall) groups54321(oinstall),54322(dba),54323(oper),54327(asmdba),54329(asmadmin) 编辑/etc/exports如下所示
[rootnas199 ~]# cat /etc/exports /backup/ 172.100.18.196(rw,sync,no_root_squash,anonuid54321,anongid54321) /backup/ 122.100.18.197(rw,sync,no_root_squash,anonuid54321,anongid54321) 修改/etc/exports后重新加载 [rootnas199 ~]# exportfs -rv exporting 172.100.18.196:/backup exporting 172.100.18.197:/backup [rootnas199 ~]#
在db1上操作
[rootdb1 ~]# showmount -e 172.100.18.199 Export list for 172.100.18.199: /backup 172.100.18.197,172.100.18.196
[rootdb1 ~]# mkdir /nasbackup [rootdb1 ~]# mount 172.100.18.199:/backup /nasbackup [rootdb1 ~]# chown -R oracle:oinstall /nasbackup [rootdb1 ~]# chmod -R 775 /nasbackup [rootdb1 ~]# df -ht nfs4 Filesystem Size Used Avail Use% Mounted on nasserver:/backup 11T 815G 11T 8% /nasbackup [rootdb1 ~]#
orcl1:/home/oracledb1 crontab -l 10 02 * * * /home/oracle/copy_to_nasbackup.sh orcl1:/home/oracledb1 cat /home/oracle/copy_to_nasbackup.sh #!/bin/bash rsync -vzurtopg --progress /backup/orcl /nasbackup /bin/find /nasbackup/orcl/rmanbackup/ -type f -name rman_* -mtime 60 -exec rm {} \; /bin/find /nasbackup/orcl/logicbacup/ -type f -name orcl_* -mtime 60 -exec rm {} \;
