Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!prodigy.net!newsmst01a.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr21.news.prodigy.com.POSTED!af4f5987!not-for-mail From: Mark Bole User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Resize redo log without making DB in restricted mode References: <1114389422.618281.210250@l41g2000cwc.googlegroups.com> <1114422961.905840.118940@f14g2000cwb.googlegroups.com> In-Reply-To: <1114422961.905840.118940@f14g2000cwb.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 54 Message-ID: NNTP-Posting-Host: 69.109.212.176 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr21.news.prodigy.com 1114439199 ST000 69.109.212.176 (Mon, 25 Apr 2005 10:26:39 EDT) NNTP-Posting-Date: Mon, 25 Apr 2005 10:26:39 EDT Organization: SBC http://yahoo.sbc.com X-UserInfo1: TSU[@I_A\S@IRVDXLZHDM^P@VZ\LPCXLLBWLOOAFEQR@ETUCCNSKQFCY@TXDX_WHSVB]ZEJLSNY\^J[CUVSA_QLFC^RQHUPH[P[NRWCCMLSNPOD_ESALHUK@TDFUZHBLJ\XGKL^NXA\EVHSP[D_C^B_^JCX^W]CHBAX]POG@SSAZQ\LE[DCNMUPG_VSC@VJM Date: Mon, 25 Apr 2005 14:26:39 GMT Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:241163 lambu999@yahoo.com wrote: >>>Hi All, >>> >>>I have a question. >>> >>>I need to resize my redo log file [...] >>> >>>This is a development machine with NO ARCHIVE LOG on. >>>I plan to do it at night time, where , not much transaction going > [...] > > alter > >>the database and switch log files until it is using the new ones. > > Then drop > >>the small ones. >>Jim > > ------------------------------------------------------------------------- > > Hi, > > - Alter system switch logfile - I presume we have to wait till > oracle starts using the bigger logfiles in this case, as there are no > commands to make Oracle switch to a specific logfile. correct? > > - In case if the logs are being archived, before dropping the old > ones we need to make sure they have been archived. I think we can find > out if the smaller logs have been archived or not from SEQUENCE# column > of v$archived_log. Is there any command to force archiver to start > archiving a particular log file or does it start archiving a log > autmoatically once a log switch happens. (and to prevent from oracle > using the smaller log, drop the smaller logfile as soon as the > archiving completes?). Any holes in my assumptions? > > Thanks. > The database of the OP is in NOARCHIVELOG mode, so the above does not apply specifically. However if it were in ARCHIVELOG mode, a more useful command than "switch logfile" would be ALTER SYSTEM ARCHIVE LOG CURRENT (or other syntax variations as shown in the docs). Yes, you can archive specific log groups, in 10g at least. -Mark Bole