Tranlogoptions rawdeviceoffset, tranlogoptions

Source: Internet
Author: User

Tranlogoptions rawdeviceoffset, tranlogoptions

Today, we will introduce the tranlogoptions rawdeviceoffset parameter in ogg. this parameter is not described in the ogg official documentation.

This parameter is used when you use a bare device.

Let's take a look at what mos says:

Oracle GoldenGate Supports Reading Redo And Archive Log files Stored On Raw Devices With Source Database On aix OS And Also Requires TRANLOGOPTIONS RAWDEVICEOFFSET Parameter (Documentation ID 1269855.1) Go to the bottom

 

In this Document

Goal
  Fix
Applies:

Oracle GoldenGate-Version 9.5 _ EA and later
Ibm aix on POWER Systems (64-bit)
* ** Checked for relevance on 06-Aug-2012 ***

GOAL

Oracle GoldenGate Supports Reading Redo And Archive Log files Stored On Raw Devices With Source Database On AIX OS

And Also Requires tranlogoptions rawdeviceoffset ParameterFIX

OGG supports redo and archive log files stored on raw devices, but if the Source database exists on aix OS then the use

Tranlogoptions rawdeviceoffset 0

May be required

RAWDEVICEOFFSET <n>

Directs Extract where to start reading on a raw device. for most operating systems, the offset is 0, but on the AIX platform it is 4096 bytes. RAWDEVICEOFFSET 0 must be used if the customer's device is configured with the-TO option. the-TO option directs Oracle not to skip the first 4096 bytes of the logical volume, but start writing at 0. (When Oracle skips the first 4096, it can cause problems with fractured blocks .) RAWDEVICEOFFSET 0 directs Extract to start reading where Oracle starts.

There is an Oracle utility named offset that helps determine the offset value, located in:
$ ORACLE_HOME/bin/offset

More Info:
The real scenario is: if "-TO" option was turned on, GoldenGate got error 22 problem; if "-TO" option was turned off, GoldenGate cocould work properly.
Below is the parameters used to generate logical volume on an AIX cluster for Oracle files:

Mklv-y 'O _ entry_d_01 '-t 'raw'-s64k'-TO counter 129 hdiskpower21 hdiskpower22 hdiskpower23 hdiskpower24 hdiskpower25 hdiskpower26 hdiskpower27 hdiskpower28

Before option "T" was turned on, GoldenGate had an "error 22" problem and cocould not be started. After option "T" was on, GoldenGate worked properly.

The default for AIX is 4096. Supported ded below are comments from IBM about option "-":
There is a fairly new-T flag on mklv that is described by CMVC Defect 389055. this flag is NOT supported ented on the mklv man page. the purpose of this flag is to use with Oracle to tell it to NOT skip the first 4096 bytes of the logical volume.

When Oracle skips the first 4096, it can cause problems with fractured blocks. when Oracle sees a type of "O" (uppercase O, not 0 zero), it will intentionally overwrite the LVCB by starting at the beginning of the LV, thus preventing fractured 4 K blocks. the problem was being seen when a halt-q was issued, and any fractured blocks became was upted.

By default, the first 4 k of each AIX Logical Volume is reserved for the Logical Volume Control Block (LVCB ). this means that the first Oracle data block begins at a 4 k offset into the Logical Volume. when fine granularity striping is used (either within aix lvm or within ess raid-5 or RAID-10 arrays ), this can result in a slight I/O performance degradation when an Oracle DB Block Size is greater than 4 k is used. (An 8 k DB Block Size is typical for OLTP applications and a 16 k DB Block size is typical for Data Warehouse applications .) this is because every few DB blocks are physically split into SS device boundaries-with the first part of the DB block residing on one physical disk and the remainder of the DB block residing on another physical disk. this can result in two physical I/OS being required to read or write a single DB block. the larger the DB Block size used, the higher the percentage of split blocks and the greater the potential for I/O performance degradation.

When running Oracle 9i Release 2 (or later), it is possible to eliminate the 4 k offset. this is recommended for new Oracle implementations or for existing applications with extremely high I/O performance requirements.

Currently, the capability to do this is delivered in two parts: An ibm aix e-fix (APAR iy000056 for AIX 5.1) and an Oracle patch (bug 2620053 ). the functionality will be supported ded in future release levels of AIX and in Oracle 9.2.0.3 or later. once the prerequisite software has been installed, do the following to take advantage of the zero offset feature:
· Create a "big" Volume Group using the mkvg-B flag.
· Create one or more Logical Volumes in that Volume group using the mklv-t o flag. the "-TO" option indicates to Oracle that it can safely use a 0 offset for this Logical Volume.

In order to eliminate the 4 k offset for an existing Oracle database, new Logical Volumes must be created and the existing data must be migrated to the new Logical Volumes using normal migration procedures.

This parameter is valid for RAC also. however, please make sure all the Database thread in RAC has the same offset/setup when using raw device for the redo log, as GoldenGate can't set specific RAWDEVICEOFFSET <n> for each thread. this has to be used ss the board for all threads.




    Related Article

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.