Home » RDBMS Server » Server Administration » LOG History in Standby DB (oracle, 10g, windows xp)
LOG History in Standby DB [message #578988] Wed, 06 March 2013 23:07 Go to next message
muktha_22
Messages: 396
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
Re: LOG History in Standby DB [message #578989 is a reply to message #578988] Wed, 06 March 2013 23:10 Go to previous messageGo to next message
BlackSwan
Messages: 22789
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;

Re: LOG History in Standby DB [message #579004 is a reply to message #578988] Thu, 07 March 2013 00:31 Go to previous messageGo to next message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you want this from the standby or the primary database?

Regards
Michel
Re: LOG History in Standby DB [message #579012 is a reply to message #579004] Thu, 07 March 2013 01:08 Go to previous messageGo to next message
muktha_22
Messages: 396
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
Re: LOG History in Standby DB [message #579022 is a reply to message #579012] Thu, 07 March 2013 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query V$ARCHIVED_LOG and V$ARCHIVE_GAP.

Regards
Michel
Re: LOG History in Standby DB [message #579117 is a reply to message #579012] Thu, 07 March 2013 21:11 Go to previous message
hkchital
Messages: 128
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
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:
  


Current Time: Thu Sep 18 15:17:36 CDT 2014

Total time taken to generate the page: 0.07235 seconds