Home » RDBMS Server » Backup & Recovery » Log generated
Log generated [message #190051] Tue, 29 August 2006 02:44 Go to next message
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
select max(SEQUENCE#) from v$log_history;
select max(SEQUENCE#) from v$log

What is the difference.Thnx in advance .
Re: Log generated [message #190129 is a reply to message #190051] Tue, 29 August 2006 05:55 Go to previous messageGo to next message
Messages: 506
Registered: March 2005
Senior Member
you can check the result of query, you will get difference... Very Happy

V$log will give active redolog sequence number which is in use.

But in V$log_history will not show current sequence number of redolog file which is in use.

See right now i don't have access to any database not even demo database, i am not sure about my answer... kindly check it out

Re: Log generated [message #196026 is a reply to message #190051] Tue, 03 October 2006 14:29 Go to previous message
Messages: 17
Registered: September 2006
Location: india
Junior Member
v$log contains information on each log group where as v$log_history contains an entry for each log switch.
the log may or may not be archived in case of v$log
but archived information is present in v$log_history
Previous Topic: restore cold backup on new server oracle 8i windows 2000 server urgent
Next Topic: How to remove a recovery catalog?
Goto Forum:

Current Time: Sun Aug 20 14:22:28 CDT 2017

Total time taken to generate the page: 0.01748 seconds