Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to change archivelog file size in oracle 11g

980965May 6 2013 — edited May 7 2013
Hello,

In my oracle 11g database inside flash recovery area how to increase each files size , now it 41 Mb per file iits name is o1_mf_1_161_8mfpwtbj_.arc how to change it to
the understandable name.

Thanks and regards
This post has been answered by saratpvv on May 6 2013
Jump to Answer

Comments

Karan
Why do you want to change the archive file size ? you should rather increase the FRA size if there is space pressure, What are you trying to achieve there ? Log archive file name is already good which tells you log sequence number and resetlogs id that gives us a unique name for the archived log file across multiple incarnations of the database.
saratpvv
It Question should be more clear - You mean , you want your arhcive logs to be in understable name ?
980965
hai,

i mean "o1_mf_1_161_8mfpwtbj_.arc" not like this adding database name , date etc.. some thing like that..
980965
Hai,

because if a big updation happens on a particular day inside fra it creates more number of records each records size is around 41 Mb , if it can fix to a fixed size the number of records should be low

thanks
Karan
Whats your redo logfile size ? Do you know archives are created with logfiles ?
saratpvv
I think you should learn more about it . here you go..

http://download.oracle.com/docs/cd/B10500_01/server.920/a96521/onlineredo.htm#7438
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/onlineredo003.htm
Mahir M. Quluzade
Hi,

As you know archived log is create when online log is switch. Archived log size might be maximum equal to online redo log size.
Because archived log size is copied from online redo log file, if you want change archived redo log size, then you must change online redo log size.
But you must think, what is advantages and disadvantages of change of online redo log size, it depends direct task LGWR process.

You can change archived redo log name with change LOG_ARCHIVE_FORMAT parameter.
See : http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams103.htm

Regards
Mahir M. Quluzade
980965
hai,
Thanks for your information
saratpvv
Answer
hai,
Thanks for your information
If you question is answerd, mark thread as answerd and keep the forum clean
Marked as Answer by 980965 · Sep 27 2020
980965
hai,

Ok
1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 4 2013
Added on May 6 2013
10 comments
4,152 views