Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to increase size of redo log files

370623May 2 2003 — edited May 2 2003

Hi,

I am working with Oracle8.1.7, and I need to increase the size of redo log files from 1 KB to at least 5 MB, since I am uploading a very large set of data, around 1.83 GB. I know that I need to create the new redo log files and then switch the old ones before dropping them. I did it once in DBSTUDIO and, it caused me to lose my connection to DB and had to finally reinstall Oracle. (I think renaming the new redo log files to REDO01.log, REDO02.log and so on caused me this. It creates them as REDO04.log and so for since I already had 3 redo log files.)

Could you please guide me through the steps I need to go to increase the size of redo log files. Please let me know if I should have my instance in MOUNTED, START, or SHUTDOWN status before doing so.

Many thanks,

Homa

Locked Post

New comments cannot be posted to this locked post.

Locked on May 30 2003

Added on May 2 2003

#general-database-discussions

3 comments

616 views