Is FAL must in Oracle 9204 [message #267852] |
Sat, 15 September 2007 13:00 |
girishta
Messages: 30 Registered: December 2006
|
Member |
|
|
As per oracle there are two types of Gap resolution in Dataguard
1. Automatic gap resolution
2. Fal
But if my standby site is brought down and a couple of archives are generated at primary ... and then i have bring up the standby ... will RFS transfer archives to standby.
Becoz in my case its not happening..
My configuration is Cascaded Dataguard.
i.e P <lan(LGWR)--->[ (standby redologs--) M (arch)]<wan ----> D
In M only archivelog files are there which are archived from standby redologs of M. And then archives are transfered to D .
|
|
|
Re: Is FAL must in Oracle 9204 [message #609660 is a reply to message #267852] |
Tue, 11 March 2014 01:23 |
|
nishant87
Messages: 53 Registered: September 2013 Location: india
|
Member |
|
|
SELECT /*+ ordered */ --PRN 13909
oh.demand_class_code,
TO_CHAR(order_number, '99999999'),
TO_CHAR(ol.line_number, '9999'),
ol.ordered_item,
mp.organization_code,
--NVL(frs.email, 'linda.bauer@emerson.com') sc_email,
NVL(NVL(oss.primary_email_address,oss.alternate_email_address),'linda.bauer@emerson.com') sc_email, TO_CHAR(ol.promise_date,'DD-Mon-YYYY') promise_dt, TO_CHAR(ol.schedule_ship_date,'DD-Mon-YYYY') sched_dt,
(SELECT d.name
FROM V$database d) db_name
FROM apps.oe_transaction_types_tl ottt,
apps.oe_transaction_types_all otta,
apps.oe_order_headers_all oh,
apps.oe_order_lines_all ol,
apps.hr_organization_units hou,
apps.xxont_som_scheduler oss,
apps.xxom_3lp_sym_ora_order_hdr xxooh,
apps.xxom_3lp_sym_ora_order_lines xxool,
--Added by OCD Project on 7th aug 2012
apps.mtl_parameters mp,
apps.oe_order_sources oos
WHERE oh.header_id = ol.header_id
AND ol.ship_from_org_id = hou.organization_id
AND hou.organization_id = mp.organization_id
AND oh.header_id = xxooh.header_id
AND xxooh.order_admin = oss.subscriber_id
AND xxool.line_id=ol.line_id --Added by OCD Project on 7th aug 2012
AND ol.org_id=xxool.org_id --Added by OCD Project on 7th aug 2012
--AND oss.subscriber_type = 'BUSINESS_ADMIN' Commented for SI
AND oh.order_type_id = otta.transaction_type_id
AND otta.transaction_type_id = ottt.transaction_type_id
AND ottt.language = USERENV('LANG') -- AND ol.link_to_line_id IS NULL commented by OCD Project on 7th aug 2012
AND ((xxool.assembly_type IS NOT NULL --Added by OCD Project on 7th aug 2012
AND ol.link_to_line_id = ol.top_model_line_id)
OR ((xxool.assembly_type IS NULL
OR xxool.assembly_type NOT IN('I','R'))
AND ol.link_to_line_id IS NULL)) --Added by OCD Project on 7th aug 2012
AND ol.ordered_quantity <> 0
AND oh.open_flag = 'Y'
AND ol.open_flag = 'Y'
AND oh.flow_status_code <> 'CLOSED'
AND oos.order_source_id = oh.order_source_id
AND oos.name <> 'Internal'
AND (ottt.name NOT LIKE '%QUOTE%'
AND ottt.name NOT LIKE '%DUMMY%'
AND ottt.name NOT LIKE '%RMA%'
AND ottt.name NOT LIKE '%BILLING ONLY%'
AND ottt.name NOT LIKE '%CREDIT ONLY%')
AND ol.ordered_item NOT LIKE 'MISC%'
AND TRUNC(ol.schedule_ship_date) = TRUNC(ol.promise_date)
AND mp.organization_code = 'RTF'
ORDER BY 1,
2,
3
|
|
|
|