Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 23-04-2009
Member
 
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 ...)?
Reply With Quote
  #2  
Old 23-04-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
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?
Reply With Quote
  #3  
Old 23-04-2009
Member
 
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?
Reply With Quote
  #4  
Old 23-04-2009
Member
 
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".
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to increase size of oracle logs"
Thread Thread Starter Forum Replies Last Post
How to Increase the shmmax parameter with Oracle database online? TEJORATH Operating Systems 5 27-05-2011 10:21 AM
How to increase icon size in MAC OS X Doroteo Customize Desktop 7 17-05-2011 05:12 PM
How to increase mailbox size in outlook Rahman Khan Windows Software 4 18-03-2011 12:03 AM
Increase in logo size strangist Customize Desktop 5 27-02-2009 10:26 PM
Increase Hotmail size to 250 MB bluediamond Technology & Internet 18 15-03-2005 08:42 AM


All times are GMT +5.5. The time now is 11:29 AM.