客戶需求對oracle數據庫做一個跨機房的備份，原環境已做rman備份和每天expdp全庫導出，遠端只有虛擬化環境，可提供一個虛擬機，2個機房間網絡互通。
首先配置nfs服務端
查看操作系統版本
[root@nas199 ~]#? more /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)
yum包
[root@nas199 ~]# yum -y install nfs-server portmap? showmount
把NFS設為開機自啟：
[root@nas199 ~]# systemctl enable nfs && systemctl start nfs
將RPC設為開機自啟：
[root@nas199 ~]# systemctl enable rpcbind &&? systemctl start rpcbind
?關閉防火墻
[root@nas199 ~]# ?systemctl stop firewalld && systemctl disable firewalld?
查看數據庫的oracle用戶id和組id
[root@db1 ~]#? id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54327(asmdba),54329(asmadmin)
?編輯/etc/exports，如下所示
[root@nas199 ~]#? cat /etc/exports
/backup/?? ?172.100.18.196(rw,sync,no_root_squash,anonuid=54321,anongid=54321)
/backup/?? ?122.100.18.197(rw,sync,no_root_squash,anonuid=54321,anongid=54321)
修改/etc/exports后重新加載?
[root@nas199 ~]#? exportfs -rv
exporting 172.100.18.196:/backup
exporting 172.100.18.197:/backup
[root@nas199 ~]#
在db1上操作
[root@db1 ~]# showmount -e 172.100.18.199
Export list for 172.100.18.199:
/backup 172.100.18.197,172.100.18.196
[root@db1 ~]# mkdir /nasbackup
[root@db1 ~]# mount 172.100.18.199:/backup /nasbackup
[root@db1 ~]# chown -R oracle:oinstall /nasbackup
[root@db1 ~]# chmod -R 775 /nasbackup
[root@db1 ~]# df -ht nfs4
Filesystem???????? Size? Used Avail Use% Mounted on
nasserver:/backup?? 11T? 815G?? 11T?? 8% /nasbackup
[root@db1 ~]#
orcl1:/home/oracle@db1> crontab -l
10 02 * * * /home/oracle/copy_to_nasbackup.sh &
orcl1:/home/oracle@db1> 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 {} \;
?
