Automatic Storage Management (ASM) is a feature provided by Oracle Corporation within the Oracle Database from release Oracle 10g (revision 1) onwards. ASM aims to simplify the management of databa...Full description
Brief discussion about Oracle ASMFull description
Oracle GG 11gFull description
Configuring Oracle 10g ASM on LinuxFull description
Full description
Installation GuideFull description
Oracle Database 10g Migration to ASM, August 2004Full description
Chapter No. 1 Getting Started Leverage the power of real-time data access for designing, building, and tuning your GoldenGate Enterprise For more information: http://bit.ly/1I4FD8g
Chapter No. 1 Getting Started Leverage the power of real-time data access for designing, building, and tuning your GoldenGate Enterprise For more information: http://bit.ly/1I4FD8gFull description
Installation Steps for Oracle 12CFull description
Interview Questions on Oracle HRMSFull description
Full description
Mlc
Descripción: snak asm
Oracle GoldenGate on ASM Steps to configure Oracle GoldenGate Extract process to read Online Redo Logs or Archived Logs stored in ASM 1) Specifying the ASM User Specify the following in extract parameter file: TranLogOptions ASMUser "sys@asm", asmpassword passwd
The ASM user can be any an y user that has the SYSDBA privilege in the ASM instance (or the SYSASM privilege in 11g onwards). 2) Updating the Listener (SID_DESC = (SID_NAME = +ASM1) (ORACLE_HOME = /u01/app//11.2.0.3/grid) This clause ensures that your listener is listening for connections on the ASM instance. Make sure to reload your listener for the chan ges to take effect. 3) Updating the TNSNAMES.ORA Finally, you need an alias in your tnsnames.ora file for the ASM connection: ASM = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server.domain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = +ASM1) (INSTANCE_NAME = +ASM1) ) )
The entry should match the alias you specified earlier in your GoldenGate ASMUser parameter. The example uses an ASMUser of sys@asm to connect in the GoldenGate parameter file, which matches your TNS entry.
Oracle GoldenGate 11g
Oracle GoldenGate 11.1 New Feature Configure the GoldenGate Extract parameter for the new Oracle ASM log read API. GoldenGate release 11.1.1 introduces a new method of reading log files stored in Oracle ASM. This new method uses the database server to access the redo and archived redo log files, instead of connecting directly to the Oracle ASM instance. The database must contain the libraries with the API modules. The libraries are currently included with Oracle Database release 10.2.0.5 and 11.2.0.2. Contact Oracle Support to request a backport for Bug 9397368 to obtain the libraries for releases (after release 10.2.0.5). To successfully mine the Oracle archived redo log files located on the storage cells that are managed by Oracle ASM, configure the GoldenGate Extract parameter as follows: 1.
Set the TRANLOGOPTIONS parameter to specify use of the new log read API. For example:
