Re: REDO LOG Concepts
- From: "DBA Deepak" <oracle.tutorials@xxxxxxxxx>
- To: "Mario Cariggi" <gelfand.transform@xxxxxxxxx>
- Date: Thu, 17 May 2007 16:36:22 +0530
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
Other related posts:
