$ su - root Password: [EMAIL PROTECTED] root]# [EMAIL PROTECTED] root]# [EMAIL PROTECTED] root]# [EMAIL PROTECTED] root]# [EMAIL PROTECTED] root]# sync [EMAIL PROTECTED] root]#
On 2003.08.22 00:34, Tim Gorman wrote:
I think the reasoning falls somewhere between the utterly rational and the insanely superstitious...
I�ve known people who would keep repeating �sync� until their fingers started tripping over one another, so I tend to see three �sync�s as the minimum. At least, that�s how it was explained to me 20 years ago: �by the time you type it in for the third time, the first one has done the job�...
Go ahead, type in �sync� just once. I dare ya...
on 8/21/03 9:04 AM, Tanel Poder at [EMAIL PROTECTED] wrote:
> Hi! > > I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* > syncs everything has been written to disk? Or it more like that after that > number of syncs, most of the changes should be on disk? (sounds stupid) > > Tanel. >> ----- Original Message ----- >> From: Tim Gorman <mailto:[EMAIL PROTECTED]> >> To: Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]> >> Sent: Thursday, August 21, 2003 12:04 AM >> Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons >> >> I�d suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to >> the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make >> me feel better)... >> >> Does anyone remember the UNIX mantra of entering �sync; sync; sync� before >> �halt�? :-) >> >> >> >> on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: >> >>> We have started waiting 90 min then do shutdown abort, startup, shutdown >>> immediate >>> >>> April Wells >>> Oracle DBA/Oracle Apps DBA >>> Corporate Systems >>> Amarillo Texas >>> >>> Few people really enjoy the simple pleasure of flying a kite >>> Adam Wells age 11 >>>> >>>> -----Original Message----- >>>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >>>> Sent: Wednesday, August 20, 2003 12:54 PM >>>> To: Multiple recipients of list ORACLE-L >>>> Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons >>>> >>>> Which brings up that thread of - if they are hard to shutdown and possibly >>>> going to crash anyway then ..... why not just wait some period of time and >>>> do the old shutdown abort. >>>>> -----Original Message----- >>>>> From: April Wells [mailto:[EMAIL PROTECTED] >>>>> Sent: Wednesday, August 20, 2003 1:00 PM >>>>> To: Multiple recipients of list ORACLE-L >>>>> Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons >>>>> >>>>> We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them >>>>> to shutdown elegantly... and they sometimes crash >>>>> >>>>> April Wells >>>>> Oracle DBA/Oracle Apps DBA >>>>> Corporate Systems >>>>> Amarillo Texas >>>>> >>>>> Few people really enjoy the simple pleasure of flying a kite >>>>> Adam Wells age 11 >>>>>> >>>>>> -----Original Message----- >>>>>> From: [EMAIL PROTECTED] >>>>>> [mailto:[EMAIL PROTECTED] >>>>>> Sent: Wednesday, August 20, 2003 11:50 AM >>>>>> To: Multiple recipients of list ORACLE-L >>>>>> Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons >>>>>> >>>>>> BTW, nothing happening in terms of processes that would hang-up the >>>>>> system. Also, I have check alert and trace files and there are no >>>>>> obvious errors. >>>>>>> -----Original Message----- >>>>>>> From: [EMAIL PROTECTED] >>>>>>> [mailto:[EMAIL PROTECTED] >>>>>>> Sent: Wednesday, August 20, 2003 12:25 PM >>>>>>> To: Multiple recipients of list ORACLE-L >>>>>>> Subject: RE: URGENT!!! My 9i databases are not shutting down >>>>>>> cleanly/cons >>>>>>> >>>>>>> >>>>>>> There seems to be a problem with consistent shutdowns in 9i >>>>>>> >>>>>>> Oracle 9i 64bit >>>>>>> >>>>>>> 9.0.1.3.0 - infrastructure database that comes with the application >>>>>>> server >>>>>>> 9.2.0.1.0 - that is the version of RDBMS we are running. >>>>>>> >>>>>>> Does anyone have problems shutting down their databases consistently >>>>>>> with 9i????? >>>>> >>>>> The information contained in this communication, including attachments, is >>>>> strictly >>>>> confidential and for the intended use of the addressee only; it may also >>>>> contain >>>>> proprietary, price sensitive, or legally privileged information. Notice is >>>>> hereby given that >>>>> any disclosure, distribution, dissemination, use, or copying of the >>>>> information by anyone >>>>> other than the intended recipient is strictly prohibited and may be >>>>> illegal. If you have >>>>> received this communication in error, please notify the sender immediately >>>>> by reply e-mail, >>>>> delete this communication, and destroy all copies. >>>>> >>>>> >>>>> Corporate Systems, Inc. has taken reasonable precautions to ensure that >>>>> any attachment to >>>>> this e-mail has been swept for viruses. We specifically disclaim all >>>>> liability and will >>>>> accept no responsibility for any damage sustained as a result of software >>>>> viruses and advise >>>>> you to carry out your own virus checks before opening any attachment. >>> The information contained in this communication, including attachments, is >>> strictly >>> confidential and for the intended use of the addressee only; it may also >>> contain >>> proprietary, price sensitive, or legally privileged information. Notice is >>> hereby given that >>> any disclosure, distribution, dissemination, use, or copying of the >>> information by anyone >>> other than the intended recipient is strictly prohibited and may be illegal. >>> If you have >>> received this communication in error, please notify the sender immediately >>> by reply e-mail, >>> delete this communication, and destroy all copies. >>> >>> >>> Corporate Systems, Inc. has taken reasonable precautions to ensure that any >>> attachment to >>> this e-mail has been swept for viruses. We specifically disclaim all >>> liability and will >>> accept no responsibility for any damage sustained as a result of software >>> viruses and advise >>> you to carry out your own virus checks before opening any attachment. >>> >> >
-- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
