通過nfs共享目錄實現oracle 歸檔日誌遠端備份

--建立目錄
--注:將節點1的備份目錄全部共享給節點2使用，並用在掛載到節點2和節點1相同的目錄下
[oracle@11grac1 backup]$ pwd
/u01/app/backup
[oracle@11grac1 backup]$ mkdir arc_all1
[oracle@11grac1 backup]$ mkdir arc_all2
[oracle@11grac1 backup]$ ll
total 20
drwxr-xr-x 2 oracle oinstall 4096 Oct 15 12:24 arc_all1
drwxr-xr-x 2 oracle oinstall 4096 Oct 15 12:24 arc_all2
drwxr-xr-x 2 oracle oinstall 4096 Oct 14 23:53 arcbak
drwxr-xr-x 2 oracle oinstall 4096 Oct 14 17:14 database_bak
drwxr-xr-x 2 oracle oinstall 4096 Oct 14 17:13 scrips


[oracle@11grac2 backup]$ mkdir arc_all1
[oracle@11grac2 backup]$ mkdir arc_all2
[oracle@11grac2 backup]$ mkdir arcbak
[oracle@11grac2 backup]$ mkdir database_bak
[oracle@11grac2 backup]$ pwd
/u01/app/backup
[oracle@11grac2 backup]$ ll
total 16
drwxr-xr-x 2 oracle oinstall 4096 Oct 15 12:24 arc_all1
drwxr-xr-x 2 oracle oinstall 4096 Oct 15 12:24 arc_all2
drwxr-xr-x 2 oracle oinstall 4096 Oct 15 12:37 arcbak
drwxr-xr-x 2 oracle oinstall 4096 Oct 15 12:37 database_bak


--共享節點1的目錄
[root@11grac1 ~]# cat /etc/exports
/u01/app/backup/arc_all1 192.168.137.162(rw)
/u01/app/backup/arc_all2 192.168.137.162(rw)
/u01/app/backup/arcbak 192.168.137.162(rw)
/u01/app/backup/database_bak 192.168.137.162(rw)
[root@11grac1 ~]# /etc/rc.d/init.d/portmap status
portmap (pid 3343) is running...
[root@11grac1 ~]# /etc/rc.d/init.d/nfs status
rpc.mountd is stopped
nfsd is stopped
rpc.rquotad is stopped
[root@11grac1 ~]# /etc/rc.d/init.d/nfs start
Starting NFS services:  [  OK  ]
Starting NFS quotas: [  OK  ]
Starting NFS daemon: [  OK  ]
Starting NFS mountd: [  OK  ]

--在節點2上掛載ntf遠端目錄
[root@11grac2 ~]# mount -t nfs -o rw 192.168.137.161:/u01/app/backup/arc_all1 /u01/app/backup/arc_all1
[root@11grac2 ~]# mount -t nfs -o rw 192.168.137.161:/u01/app/backup/arc_all2 /u01/app/backup/arc_all2
[root@11grac2 ~]# mount -t nfs -o rw 192.168.137.161:/u01/app/backup/arcbak /u01/app/backup/arcbak
[root@11grac2 ~]# mount -t nfs -o rw 192.168.137.161:/u01/app/backup/arcbak /u01/app/backup/database_bak

--修改引數（pfile和spfile進行轉換）
--引數檔案新增以下
racdb1.log_archive_dest_1='location=/u01/app/backup/arc_all1'
racdb1.log_archive_dest_2='location=/u01/app/backup/arc_all2'
racdb2.log_archive_dest_1='location=/u01/app/backup/arc_all1'
racdb2.log_archive_dest_2='location=/u01/app/backup/arc_all2'
--重啟資料庫所有例項，使引數生效

--2個節點切換日誌，驗證歸檔正常
SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.
[root@11grac1 arc_all1]# ll
total 32
-rw-r----- 1 oracle asmadmin 1024 Oct 15 15:21 1_107_792522404.dbf
-rw-r----- 1 oracle asmadmin 1024 Oct 15 15:21 1_108_792522404.dbf
-rw-r----- 1 oracle asmadmin 1024 Oct 15 15:21 1_109_792522404.dbf
-rw-r----- 1 oracle asmadmin 1024 Oct 15 15:21 1_110_792522404.dbf
-rw-r----- 1 oracle asmadmin 1024 Oct 15 15:21 2_78_792522404.dbf
-rw-r----- 1 oracle asmadmin 1024 Oct 15 15:21 2_79_792522404.dbf
-rw-r----- 1 oracle asmadmin 1024 Oct 15 15:21 2_80_792522404.dbf
-rw-r----- 1 oracle asmadmin 1024 Oct 15 15:21 2_81_792522404.dbf

--此刻，便通過nfs共享目錄實現了oracle 歸檔日誌遠端備份的目的。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26143577/viewspace-746456/，如需轉載，請註明出處，否則將追究法律責任。