OraFAQ Forum: Server Administration » Droping redolog file?

Home » RDBMS Server » Server Administration » Droping redolog file?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Droping redolog file? [message #115193]

Fri, 08 April 2005 01:42

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,,, every one

Can any one tell me if i have 5 redolog file and if i drop 2 redolog file .... does oracle is going to complain for it ...
Is it so that my database is crash by droping 2 redolog file out of 5 redolog file?

Note:- Two redolog file must be present so that database can work properly.

friend
sunil
+91-9871147781

Report message to a moderator

Re: Droping redolog file? [message #115337 is a reply to message #115193]

Sat, 09 April 2005 16:34

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

I guess you meant to say: two redolog groups (instead of files) must be present.

Dropping logfile groups/members should not cause any downtime. However, study section "Dropping Log Groups" in the Oracle Database Administrator's Guide before starting.

Here is a quick example:

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
         1          1        131   10485760          1 NO  INACTIVE               1478735 04-APR-05
         2          1        132   10485760          1 NO  ACTIVE                 1503046 09-APR-05
         3          1        133   10485760          1 NO  CURRENT                1505530 09-APR-05

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> ALTER SYSTEM CHECKPOINT;

System altered.

SQL> ALTER DATABASE DROP LOGFILE GROUP 3;

Database altered.

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
         1          1        134   10485760          1 NO  CURRENT                1506559 09-APR-05
         2          1        132   10485760          1 NO  INACTIVE               1503046 09-APR-05

Best regards.

Frank

Report message to a moderator

Re: Droping redolog file? [message #115467 is a reply to message #115193]

Mon, 11 April 2005 16:56

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Note that Frank did that switch logfile so that he could drop the group, because it was current.

Note also that 5 groups really isn't all that many, so make sure you have a good reason to be cutting it down.

Report message to a moderator

Previous Topic:	CPU allocation per user
Next Topic:	Comparing table structures in Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:28:07 CDT 2024