Re: REDO LOG Concepts
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: "DBA Deepak" <oracle.tutorials@xxxxxxxxx>
- Date: Thu, 17 May 2007 13:08:18 +0200
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@xxxxxxxxx> 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@xxxxxxxxx> wrote:
>
> On 5/17/07, DBA Deepak <oracle.tutorials@xxxxxxxxx> 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@xxxxxxxxxxxx
http://www.trivadis.com
=========================
Other related posts:
