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 .

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Previous Topic: Archive Log files
Next Topic: RMAN Backup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 12:01:20 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.