--创建目录
--注:将节点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/,如需转载,请注明出处,否则将追究法律责任。