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
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
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
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
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
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