oracle 远程共享文件夹,通过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/，如需转载，请注明出处，否则将追究法律责任。