RE: redo log maintenance

2003-06-27 Thread Koivu, Lisa
Title: redo log maintenance Thought so. Thanks Mladen. -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Thursday, June 26, 2003 5:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: redo log maintenance Doco is plain wrong. I've been adding

redo log maintenance

2003-06-26 Thread Koivu, Lisa
Title: redo log maintenance I'm reading through the 9.2 admin guide (yawn) and it says that the database must be mounted but not open to add, drop or rename redo logs. I have done this many times with the database up and running, with no problems. Why would it say this in the doco

RE: redo log maintenance

2003-06-26 Thread Gogala, Mladen
Title: redo log maintenance Doco is plain wrong. I've been adding, dropping and switching logfiles ever since the version 6 and I have never needed to shut down the database for it. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From

Re: redo log maintenance

2003-06-26 Thread Ron Rogers
Lisa, I do not have the pleasure of migrating to 9.2 yet, In a few months maybe on my play box. Could it be that the docs are refering to the AUTO UNDO function that is availabe in 9i? I, like you have offlined, dropped and rebuilt redo logs on the fly without any problems. Ron [EMAIL

RE: redo log maintenance

2003-06-26 Thread Goulet, Dick
Title: redo log maintenance Lets just say that the docs are erroring on the safe side. The reason is that if you try to do any of these tasks with the database open you could be affecting (negatively) an active log file. While I agree with both of you that you can make these mods while

Re: redo log maintenance

2003-06-26 Thread Tanel Poder
Title: redo log maintenance Hi! You won't be affecting anycurrent redolog negatively, you simply get an error, but the normal work continues as usual... tnl. - Original Message - From: Goulet, Dick To: Multiple recipients of list ORACLE-L Sent: Friday, June 27