And since DBRn writes every three seconds, Rajendra's explanation only
covers a max. of those last three seconds of data.

[Email Address Removed] Original Message -----
From: "Rajendra Prakash" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Monday, September 30, 2002 6:15 AM
Subject: Re: Commtted DATA


> when instance recovery is done then all redo log file data is roll
forword.
> In roll forword phase it is written to the datafile whether it is commited
> or un commited. at this point rollback segment is populated.Rollback
segment
> entry will be done if not present for un commited data. then rollback is
> done. At this point of time, datafile may have un commited data also. as
> blocks are needed in buffer cache , data is rolled back.
> Regards,
> Rajendra Prakash
> ----- Original Message -----
> From: Deepak Kulkarni <deepak.[Email Address Removed] To: LazyDBA.com Discussion <[Email Address Removed] Sent: Monday, September 30, 2002 4:16 PM
> Subject: Commtted DATA
>
>
> > Hi DBAs,
> >
> > How does a commit ensures that 'Committed Data' is available when a
> database
> > is reopened after crash ?
> >
> > Bcoz commit only ensures that data is written to Redo logs & not to data
> > files !!
> >
> > Kindly help.
> >
> > Regards
> > Deepak Kulkarni
> > Sr. Software Engineer
> > > CyberTech Systems and Software Ltd.
> > > B-65, CyberTech House, J B Sawant Marg,
> > > Rd. No. 21, Wagle Estate, Thane 400 604.
> > > Call: 583 46 43/44/45 Extn 2241
> > > ===============================================
> > > "No major application will run in Third Normal Form"
> > > George Koch --- ORACLE8 : The complete
> > > Reference
> > > ===============================================
> > >
> > >
> > >
> > >
> > >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.391 / Virus Database: 222 - Release Date: 9/19/2002
> >
> >
> > --------
> > Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to oracledba-[Email Address Removed] > To subscribe: send a blank email to oracledba-[Email Address Removed] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>

Oracle LazyDBA home page