1. When DDL is active, will be not able to perform Filtering,Mapping,Transformation of data.
2. Using GG - We can replicate DML and DDL Operations.
3. Can we move similar or dissimilar data across different Oracle Versions - YES.
4. GG Supports - Filtering,Mapping,Transformation of data.
5. Trail Files can reside on NAS / SAN
6. How do you estimate trail space.
To estimate required trail space
1. Estimate the longest time that the network could be unavailable. Plan to store enough
data to withstand the longest possible outage, because otherwise you will need to
resynchronize the source and target data if the outage outlasts disk capacity.
2. Estimate how much transaction log volume your business applications generate in one
hour.
3. Use the following formula to calculate the required disk space.
[log volume in one hour] x [number of hours downtime] x .4 = trail disk space