OraFAQ Forum: Server Administration » LOG History in Standby DB

Home » RDBMS Server » Server Administration » LOG History in Standby DB (oracle, 10g, windows xp)

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

LOG History in Standby DB [message #578988]

Wed, 06 March 2013 23:07

muktha_22
Messages: 341
Registered: December 2009

Senior Member

Hello All,

I need your help on the below query.

I want to know the DATE, LOG SEQUENCE NUMBER which was applied in the Standby (DR)one year before.

I am not able to get through "v$log_history".

Regards
muthu

Report message to a moderator

Re: LOG History in Standby DB [message #578989 is a reply to message #578988]

Wed, 06 March 2013 23:10

BlackSwan
Messages: 20245
Registered: January 2009

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

post results from SQL below

select min(first_time) from v$log_history;

Report message to a moderator

Re: LOG History in Standby DB [message #579004 is a reply to message #578988]

Thu, 07 March 2013 00:31

Michel Cadot
Messages: 54717
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do you want this from the standby or the primary database?

Regards
Michel

Report message to a moderator

Re: LOG History in Standby DB [message #579012 is a reply to message #579004]

Thu, 07 March 2013 01:08

muktha_22
Messages: 341
Registered: December 2009

Senior Member

Hello Michel,

From anywhere, But i need the proof of the logs APPLIED for the last one year.

Regards
Muthu

Report message to a moderator

Re: LOG History in Standby DB [message #579022 is a reply to message #579012]

Thu, 07 March 2013 01:29

Michel Cadot
Messages: 54717
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Query V$ARCHIVED_LOG and V$ARCHIVE_GAP.

Regards
Michel

Report message to a moderator

Re: LOG History in Standby DB [message #579117 is a reply to message #579012]

Thu, 07 March 2013 21:11

hkchital
Messages: 119
Registered: September 2008
Location: Singapore

Senior Member

If it is one year ago, your best shot would be to go through the alert.log file for the Standby

Hemant K Chitale

Report message to a moderator

Previous Topic:	upgrade from 9.2.0.8 2 node RAC to 11.2.0.3 2 node RAC.. please review plan
Next Topic:	Oracle Database Connection Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 23:59:48 CDT 2013

Total time taken to generate the page: 0.15668 seconds