Re: alter system switch logfile hangs

From: MarkP28665 <markp28665_at_aol.com>
Date: 14 Oct 1998 22:44:48 GMT
Message-ID: <19981014184448.27305.00000390@ng-cr1.aol.com>

From: nordby_at_channelpoint.com >>>
Anyone see this behavior, or have any clues on how to figure this out? <<<

Question, How you verified that the log you are trying to switch to has been archived? If it has not then you would see this. Also if Oracle is trying to archive the file and your backup scripts gets to it before Oracle does then it will not be a good backup. Also a log switch requires a checkpoint which means all dirty buffers must be written to disk. Therefore you should be issuing the log switch after all tablespaces are brought out of backup mode.

If it has been archived then you will probably need to contact Oracle support after checking the alert log and looking from trace files.

I hope this gives you a few things to check if you already haven't. Good luck.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Wed Oct 14 1998 - 17:44:48 CDT