Re: Alter system switch logfile hang

What does give you:
archive log list;

Is *should* be:
Database log mode              *Archive Mode*
Automatic archival             *Enabled*
Archive destination            h:\oradata\DB1\archive
Oldest online log sequence     66
Next log sequence to archive   68
Current log sequence           68

And,:
show parameter archive

log_archive_dest_1                                               string
LOCATION=h:\oradata\DB1\archive

log_archive_dest_state_1                                         string
*enable*

also:
select GROUP#, ARCHIVED, STATUS from v$log;

GROUP# ARC STATUS
------ --- --------
     2 YES INACTIVE
     3 NO  CURRENT
     4 YES INACTIVE


The systems probably waiting for an archive log, i.e. in the query above ARC = 
NO.  I guess your system isn't autoamtically archiving, i.e. 
log_archive_dest_state_1 (or other dest number *or* plain 
log_archive_dest_state)  is not set to enable. You do this by hand now, then 
set up automatic archival:

alter system archive log all;

alter system set log_archive_dest_state_1=enable scope=sfpile;

bounce database.

HTH
Cheers
Tony







  ----- Original Message ----- 
  From: DBA Deepak 
  To: oracle-l@xxxxxxxxxxxxx 
  Sent: Tuesday, November 08, 2005 6:33 AM
  Subject: Alter system switch logfile hang


  Hi All,

  The alter system switch logfile hangs in my database.

  > The archive destination is valid and having all the necessary permissions.
  > v$session_wait has long waits on "switch logfile command".

  What might be the reason, what else should I check for?

  -- 
  Regards,

  Deepak
  Oracle DBA

Other related posts: