All about goldengate

以下是关于Goldengate 是安装在本地文件系统还是共享文件系统的资料， 说明goldengate 是可以安在本地文件系统或共享文件系统，只不过安在本地文件系统有弊端。

There are multiple variations of installing GoldenGate for Oracle RAC.

Solution Details:
Installing GoldenGate on Shared Drives
This approach works very well. The software is installed on shared drives that all the RAC nodes have access to. The manager and GoldenGate processes can be started from one of the nodes. If the node that the GoldenGate processes were started from fails, the checkpoints are maintained. The manager and GoldenGate processes then can be started from another node without making any modifications to any parameter files. If the database alone crashes on the node that GoldenGate was installed, then the manager process will need to be stopped on that node before it be restarted on another node.


Installing GoldenGate on local disk
This approach will not work in a fail over situation. If there was a database failure alone on this node, the software could be installed on a different node. For the replicat , all the trails would need to be moved to that node. The extract and replicat could be added and positioned to that last known good checkpoint. If there were a complete node failure, this would be very difficult to recover from. It would be impossible to know what the last good checkpoint was and we would have no access to any trails that were located on those local disks.

Connecting to the RAC instance from a application server using SQL*Net
The software is installed on a separate machine. GoldenGate is setup to connect to the RAC Instance via the Global Database name which is setup in TNSNAME.ORA. By connecting to the Global Database using SQL*Net, Oracle will handle the fail over. For extract, the oracle logs will need to be located on shared disk that this server has access to.

When adding your online Extract groups, be sure to specify the THREADS option on the ADD command.

How do you access multiple Oracle Instances from 1 GoldenGate Instance?

Each Oracle instance can be accessed from Extract or Replicat using the SETENV parameter. This parameter will override the environmental variables set in the users profile for the GoldenGate user. Place this parameter before the login statement in your parameter file.
example:
SETENV (ORACLE_SID = ORA920)

配置Oracle ACFS集群文件系统

ASM Cluster File System (ACFS)
The ASM Cluster File System (ACFS), extends Automatic Storage Management (ASM) by providing a robust, modern, general purpose file system for files beyond the Oracle database files. ACFS provides support for files such as Oracle binaries, report files,trace files, alert logs, and other application data files. With the addition of the Oracle ASM Cluster File System, ASM becomes a complete storage management solution for both Oracle database and non-database files.

ACFS supports large files with 64-bit file and file system data structure sizes leading to exabyte-capable file and file system capacities. ACFS scales to hundreds of nodes and uses extent-based storage allocation for improved performance. A log-based metadata transaction engine is used for file system integrity and fast recovery. The ACFS on-disk structure supports endian neutral metadata. ACFS file systems can be exported to remote clients through industry standard protocols such as NFS and CIFS.

Oracle ASM Cluster File System (ACFS) complements and leverages Automatic Storage Management (ASM) and provides a general purpose journaling file system for storing and managing non-Oracle database files. This eliminates the need for expensive third party cluster file system solutions while streamlining, automating and simplifying all file type management in a single node as well as Oracle RAC and Grid computing environments.

ACFS supports dynamic file system expansion and contraction without any downtime. ACFS is highly available leveraging the ASM mirroring and striping features in addition to hardware RAID functionality.

oracle官方定义：
Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a multi-platform, scalable file system, and storage management technology that extends Oracle Automatic Storage Management (Oracle ASM) functionality to support customer files maintained outside of Oracle Database. Oracle ACFS supports many database and application files, including executables,database trace files, database alert logs, application reports, BFILEs, and configuration files. Other supported files are video, audio, text, images, engineering drawings, and other general-purpose application file data.
大意是ACFS是一个支持多个平台，可扩展的，基于ASM的集群文件系统，可以用来存储数据库和各种应用的文件，包括数据库的trace文件，alert日志文件和配置文件等等，也可以用来存储视频，音频，文本，图片等文件。
在这之前，集群文件系统使用过redhat 的gfs，还有开源的ocfs2，gfs的感觉是配置太繁琐且复杂，因为是基于RHCS套件，所以很多功能对应单纯的集群文件系统来说显得有些冗余；ocfs2 属于被放弃的孩子，目前已经停止开发了，不过胜在配置简单；ACFS 在11g r2中推出，基于grid infrastructure，配置上也算容易，且在ASM的基础上进行发展，稳定性应该还是有保证的，下一步打算利用ACFS测试下rac环境下的golden gate复制！下面来介绍下11G RAC环境下ACFS的使用！

一：查看acfs相关的服务是否正常
[grid@rac1 ~]$ crs_stat -t -v ora.registry.acfs  
Name           Type           R/RA   F/FT   Target    State     Host          
----------------------------------------------------------------------  
ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    rac1     
 
[grid@rac1 ~]$ crs_stat -t -v ora.ACFS.dg  
Name           Type           R/RA   F/FT   Target    State     Host          
----------------------------------------------------------------------  
ora.ACFS.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    rac1

二：使用asmca图形化工具，在asm磁盘组中创建volume并格式化成ACFS文件系统
[root@rac1 ~]# su - grid  
[grid@rac1 ~]$ !exp  
export DISPLAY=192.168.1.105:0  
[grid@rac1 ~]$ asmca