Home » Server Options » Data Guard » Is FAL must in Oracle 9204
Is FAL must in Oracle 9204 [message #267852] Sat, 15 September 2007 13:00 Go to next message
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 Go to previous messageGo to next message
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
Re: Is FAL must in Oracle 9204 [message #609664 is a reply to message #609660] Tue, 11 March 2014 01:46 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not an expert, but - what does this code have to do with the question? Did you, by any chance, misplace it?
Previous Topic: ORA-16224: Database Guard is enabled
Next Topic: Physical StandBy on a Standard Edition 11.2
Goto Forum:
  


Current Time: Fri Mar 29 07:57:12 CDT 2024