Re: REDO LOG Concepts

That won't work if Oracle still writes to the file while copying.

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.
>
> Deepak
>
>
> On 5/17/07, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:
> >
> > I've run into this situation before as well. It happens, people
> > accidentally delete files.
> >
> > What would be interesting to research, is if you still can somehow
> > recover those files. As they're still there, and locked by the process
> > accessing them (in your case LGWR), there might be a way to "steal" the
> > filehandle from that process and just write the file to another location
> > before it's being closed. Though you would have to intercept the syscall
> > closing the file.
> >
> > Anyone ever heard of any research on this ?
> >
> > Stefan
> >
> > On 5/17/07, DBA Deepak <oracle.tutorials_at_gmail.com > wrote:
> > >
> > > Hi Alexander,
> > >
> > > I do not think UNIX removes the directory entry immediately. Otherwise
> > > how would it access the REDO logs by their paths.
> > >
> > > What might be happening is UNIX is marking it as deleted (may be using
> > > a flag or so). Please do correct me if am wrong.
> > >
> > > Deepak
> > >
> > >
> > > On 5/17/07, Alexander Fatkulin <afatkulin_at_gmail.com > wrote:
> > > >
> > > > Deepak,
> > > >
> > > > As others have already pointed out - you actually didn't delete
> > > > anything. You just unlinked a directory entry in a file system. File
> > > >
> > > > is still "there" and is open by the LGWR.
> > > >
> > > > Shutdown immediate is a clean shutdown (no instance recovery is
> > > > required after it).
> > > >
> > > > On 5/17/07, DBA Deepak < oracle.tutorials_at_gmail.com> wrote:
> > > > > Hi All,
> > > > >
> > > > > As we know when we issue a COMMIT the log buffer content is
> > > > flushed to the
> > > > > online redo log file before the "Commit complete" status is
> > > > returned to the
> > > > > user. Please correct me if I am wrong.
> > > > >
> > > > > I have the following scenario...
> > > > >
> > > > > SQL> select member from v$logfile;
> > > > >
> > > > > MEMBER
> > > > >
> > > > --------------------------------------------------------------------------------
> > > >
> > > > > /u04/oradata/BIDWDB01/redo03.log
> > > > > /u04/oradata/BIDWDB01/redo02.log
> > > > > /u04/oradata/BIDWDB01/redo01.log
> > > > >
> > > > > SQL> !rm /u04/oradata/BIDWDB01/redo01.log
> > > > >
> > > > > SQL> !rm /u04/oradata/BIDWDB01/redo02.log
> > > > >
> > > > > SQL> !rm /u04/oradata/BIDWDB01/redo03.log
> > > > >
> > > > >
> > > > > SQL> connect scott/oracle
> > > > > Connected.
> > > > > SQL> update emp set ename=ename;
> > > > >
> > > > > 14 rows updated.
> > > > >
> > > > > SQL> commit;
> > > > >
> > > > > Commit complete.
> > > > >
> > > > > SQL> commit;
> > > > >
> > > > > Commit complete.
> > > > >
> > > > > SQL> conn / as sysdba
> > > > > Connected.
> > > > > SQL> shutdown immediate
> > > > > Database closed.
> > > > > Database dismounted.
> > > > > ORACLE instance shut down.
> > > > >
> > > > >
> > > > > SQL> startup
> > > > > ORACLE instance started.
> > > > >
> > > > > Total System Global Area 4479516672 bytes
> > > > > Fixed Size 1984504 bytes
> > > > > Variable Size 905975816 bytes
> > > > > Database Buffers 3556769792 bytes
> > > > > Redo Buffers 14786560 bytes
> > > > > Database mounted.
> > > > > ORA-00313: open failed for members of log group 1 of thread 1
> > > > > ORA-00312: online log 1 thread 1:
> > > > > '/u04/oradata/BIDWDB01/redo01.log'
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > -----------------------
> > > > >
> > > > > My question is even after deleting all the online redo log files
> > > > how did
> > > > > Oracle returned the Commit complete status to the user? What
> > > > happened to the
> > > > > log buffer data flush?
> > > > >
> > > > > I am using 10.2.0.2 on Solaris 9 (64-bit)
> > > > >
> > > > >
> > > > > Regards,
> > > > >
> > > > > Deepak
> > > >
> > > >
> > > > --
> > > > Alexander Fatkulin
> > > >
> > >
> > >
> > >
> > > --
> > > 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
> >
> > =========================
>
>
>
>
> --
> 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