Home » Server Options » Data Guard » No of archivelog generation between the period in RAC envirnoment (10g, 10.2.0.5, hp unix)
No of archivelog generation between the period in RAC envirnoment [message #652903] Wed, 22 June 2016 02:18 Go to next message
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-

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
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 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
There is no format specifier hh21, is that the problem?
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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'"?

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 Go to previous messageGo to next message
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).

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?
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.

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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.

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


Current Time: Thu Mar 28 06:33:24 CDT 2024