| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Resizing Log file
You can recreate the control file with resetlog options.
Use "Alter database backup controlfile to trace;"
Open the trace file generated then change the size of the logfile, and also noresetlogs to resetlogs.
then startup with nomount and create the controlfile and open the db.
Caution: this will reset ur logs, so u have to backup the after u open the db backupup the db.
HTH,
-- On Fri, 01 Jun 2001 07:15:45 Christopher Spence wrote:Received on Fri Jun 01 2001 - 12:11:27 CDT
>Create new groups, drop the old ones.
>
>"Walking on water and developing software from a specification are easy if
>both are frozen."
>
>Christopher R. Spence
>Oracle DBA
>Fuelspot
>
>
>
>-----Original Message-----
>Sent: Thursday, May 31, 2001 3:38 PM
>To: Multiple recipients of list ORACLE-L
>
>
>hi dba's,
>
>In my DB, oracle 816, NT4, the redolog member's size is only 50kb. I'm
>having only two groups with a single member each.
>
>I tried with alter database command, there is only options for adding and
>droping log group or member...
>
>How can i resize it.. to increase the size 5mb.
>
>Regards,
>Nirmal.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Nirmal Kumar Muthu Kumaran
> INET: NIRMALK_at_qtel.com.qa
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Christopher Spence
> INET: cspence_at_FuelSpot.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (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).
>
Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: csvenkata_at_lycos.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).
 |
 |