OraFAQ Forum: Data Guard » No of archivelog generation between the period in RAC envirnoment

Home » Server Options » Data Guard » No of archivelog generation between the period in RAC envirnoment (10g, 10.2.0.5, hp unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

No of archivelog generation between the period in RAC envirnoment [message #652903]

Wed, 22 June 2016 02:18

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear All,

While generating report for number of archivelog generated between the period is getting confused.

Below is the query I was using to generate report-

Code: [Select all] [Show/ hide]

select count(*) from gv$archived_log
where dest_id=1
and applied='NO'
and completion_time between to_date('20/06/2016 09:00:00', 'dd/mm/yyyy hh21:mi:ss') and to_date('20/06/2016 18:00:00', 'dd/mm/yyyy hh21:mi:ss')
order by next_time desc;

Kindly help me out, to get correct report on RAC envirnoment. Here, thread is also making me confused.

Regards,
Ashish

Report message to a moderator

Re: No of archivelog generation between the period in RAC envirnoment [message #652905 is a reply to message #652903]

Wed, 22 June 2016 02:46

John Watson
Messages: 8978
Registered: January 2010
Location: Global Village

Senior Member

There is no format specifier hh21, is that the problem?

Report message to a moderator

Re: No of archivelog generation between the period in RAC envirnoment [message #652907 is a reply to message #652903]

Wed, 22 June 2016 02:50

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you told us what the query should return then we could give you a correct query.
Why do you post this in "Data Guard" forum? Is there something to do with Data Guard?
What is confusing you?
Why do you use this query? I mean how did you write it? For what purpose? Why "applied='NO'"?

Report message to a moderator

Re: No of archivelog generation between the period in RAC envirnoment [message #652911 is a reply to message #652907]

Wed, 22 June 2016 03:20

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear Michel,

commented APPLIED='NO

I would like to know, how many number of archive log generated at ods-logical (query executed from ods-node1).

Code: [Select all] [Show/ hide]

select count(*) from gv$archived_log
where dest_id=1
and completion_time between to_date('20/06/2016 09:00:00', 'dd/mm/yyyy hh21:mi:ss') and to_date('20/06/2016 18:00:00', 'dd/mm/yyyy hh21:mi:ss')
order by next_time desc;

'Here, thread is 1 & 2. Is this query is correct to get no of archive log generated at ODS?

Report message to a moderator

Re: No of archivelog generation between the period in RAC envirnoment [message #652912 is a reply to message #652911]

Wed, 22 June 2016 03:24

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is ODS?
You talk about ods-logical and ods-node1 (without explaining us what they are) and you ask a question about ODS?
You have to be clearer in your question. We know NOTHING about your architecture.

Report message to a moderator

Re: No of archivelog generation between the period in RAC envirnoment [message #652914 is a reply to message #652912]

Wed, 22 June 2016 04:03

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear Michel,

Its all about logical standby data guard. Where log is getting shipped from primary database and sql apply is happening on it. -- this is what I mean for ODS-logical. But my question was wrongly asked. Apologize !!!

Things are like below-

Query is executed from node1 out of 2-node primary database. We need to generate output of number of archive log generated by both the primary database (RAC)?

Hope, its clear now.

Thanks

[Updated on: Wed, 22 June 2016 04:25]

Report message to a moderator

Re: No of archivelog generation between the period in RAC envirnoment [message #652941 is a reply to message #652914]

Wed, 22 June 2016 09:23

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

v$archived_log contains the logs of both nodes/threads, you don't need gv$ in this case but for very few special case.
Query gv$ and you will see you have the same thing with inst_id=1 and inst_id=2.

Report message to a moderator

Previous Topic:	Replace string
Next Topic:	Standby database creation (Primary db RACOnenode) standby db in single instance db having asm disk

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 21 09:34:17 CDT 2025