Home » RDBMS Server » Backup & Recovery » Log generated
Log generated [message #190051] Tue, 29 August 2006 02:44 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
select max(SEQUENCE#) from v$log_history;
and
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
sunil_v_mishra
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

cheers..!
Sunilkumar
Re: Log generated [message #196026 is a reply to message #190051] Tue, 03 October 2006 14:29 Go to previous message
parthokonar
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: Archive Log files
Next Topic: RMAN Backup
Goto Forum:
  


Current Time: Sat Dec 10 08:44:04 CST 2016

Total time taken to generate the page: 0.08166 seconds