Results 1 to 4 of 4

Thread: How to increase size of oracle logs

  1. #1
    Join Date
    Mar 2009
    Posts
    1,360

    How to increase size of oracle logs

    I work on an oracle 10g.

    The max size of ARCHIVELOG is currently 4 GB. Many archives are generated, therefore increase the size but I do not know how (base closed, open, static, command line ...)?

  2. #2
    Join Date
    Jan 2008
    Posts
    1,521

    Re: How to increase size of oracle logs

    Already before changing anything in the flash recovery area, it is preferable to ensure that your base is with the flash recovery area

    But what would you increase? the size of each file in ARCHIVELOG? the size of the flash recovery area?

  3. #3
    Join Date
    Mar 2009
    Posts
    1,360

    Re: How to increase size of oracle logs

    A backup is made with hot rman (ARCHIVELOG mode = ON). The archives are stored in the [ORACLE_HOME]\flash_recovery_area\SID\ARCHIVELOG\dateToday.

    The archives are deleted after the backup rman. The size of the file (dateToday) with the archive is 4 GB.

    The size of this file that I want to grow.

    Other questions to pass. How to know the max file size of flash recovery area?

  4. #4
    Join Date
    May 2008
    Posts
    3,971

    Re: How to increase size of oracle logs

    Max File size:

    Code:
    SHOW parameters DB_RECOVERY_FILE_DEST_SIZE
    DB_RECOVERY_FILE_DEST_SIZE:

    Parameter type: Big integer
    Syntax: DB_RECOVERY_FILE_DEST_SIZE = integer [K | M | G]
    Default value: There is no default value.
    Modifiable: ALTER SYSTEM ... SID='*'
    Basic: Yes
    Real Application Clusters: You must set this parameter for every instance, and multiple instances must have the same value.

    DB_RECOVERY_FILE_DEST_SIZE specifies (in bytes) the hard limit on the total space to be used by target database recovery files created in the flash recovery area.

    I would say it is valued up to 4GB. You can increase it with "ALTER SYSTEM".

Similar Threads

  1. Replies: 5
    Last Post: 27-05-2011, 10:21 AM
  2. How to increase icon size in MAC OS X
    By Doroteo in forum Customize Desktop
    Replies: 7
    Last Post: 17-05-2011, 05:12 PM
  3. How to increase mailbox size in outlook
    By Rahman Khan in forum Windows Software
    Replies: 4
    Last Post: 18-03-2011, 12:03 AM
  4. Increase in logo size
    By strangist in forum Customize Desktop
    Replies: 5
    Last Post: 27-02-2009, 10:26 PM
  5. Increase Hotmail size to 250 MB
    By bluediamond in forum Technology & Internet
    Replies: 18
    Last Post: 15-03-2005, 08:42 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,652,457.66726 seconds with 17 queries