Re: REDO LOG Concepts

If you have "lsof" installed - that will show you every open file on the system. Just grep for the appropriate filename / pid

Stefan

On 5/17/07, DBA Deepak <oracle.tutorials_at_gmail.com> wrote:
>
> I think both LGWR and ARC processes keep all the log files open, because I
> could do a log file switch and generate archive logs. But is there any way
> to see what all processes have lock on the redo log files in Solaris?
>
> Would like to know which process does UTL_FILE use/spawn to create/access
> files? Is n't it the Oracle Server process? If yes, in my experiment I had
> deleted the datafile and could read the tables on that datafile. Then why
> can't the we copy the files through UTL_FILE?
>
> Please share your thoughts.
>
>
> Deepak
>
> On 5/17/07, Mario Cariggi <gelfand.transform_at_gmail.com> wrote:
> >
> > On 5/17/07, DBA Deepak <oracle.tutorials_at_gmail.com> wrote:
> > > Can we use UTL_FILE to copy the file as seen by oracle itself to a
> > separate
> > > location? Am suggesting the use of something like UTL_FILE because
> > UTL_FILE
> > > will be running from within Oracle's environment and Oracle can still
> > see
> > > the file.
> >
> > but Oracle works with processes (under unix machine):
> > from your shadow process (the one that tries to open the
> > redo log file with the utl_file) you won't see the redo log file
> > anymore; only those processes that still keep open the file
> > could see it.
> >
> > Regards.
> >
> > Mario.
> >
>
>
>
> --
> Regards,
>
> Deepak
> Oracle DBA

-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

=========================

--
http://www.freelists.org/webpage/oracle-l