If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

archive size

Archive size is the size of rollback segments. You can not change it. However, if you give alter system swich logfile, it will archive the unfilled long and the size of that particular archive redo log will be smaller than others.

Hey, kkpareek watch out, archive size does not depend on rollback segment. As jdorlon says, it depends on the online redo log file. But again, the redo log file size CAN BE CHANGED. Be careful to do this and if U'r not experienced please do under experts supervision only. Follow these steps to change the size of Online Redolog file.
- Note the current redo log file & switch the control to the next redo log group
- Drop the redo log file and recreate with size U require
- Again switch the control to the next redo log group and drop the one which was online earlier.
- Create a Redo log group with size(same size as previous recomended) that you require.
- Similarly proceed the above steps as mentioned above.

P.s If U have only two redo log groups only, then please don't forget to create the third one, without which the whole operation will not work