Home » RDBMS Server » Backup & Recovery » FRA size issue
FRA size issue [message #264780] Tue, 04 September 2007 10:14 Go to next message
sroy
Messages: 38
Registered: July 2005
Member
Any suggestion about controlling/tuning FRA size so backup (incremental 0 and 1 level) of huge database won't cause it grow fast unexpectedly? We used backup retention policy, report/delete obsolete and db_flashback_renetion_target parameter in this effort. But, why was I getting 80% or more in FRA?
Re: FRA size issue [message #264782 is a reply to message #264780] Tue, 04 September 2007 10:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
what is your DB_RECOVERY_FILE_DEST_SIZE parameter value.
what is your Oracle DB size.

FRA maintain by Oracle Server and any flashback files automatially deleted if space required.

According your retention policy obsolete/expired file deleted


Regards
Taj
Re: FRA size issue [message #264788 is a reply to message #264780] Tue, 04 September 2007 10:36 Go to previous messageGo to next message
sroy
Messages: 38
Registered: July 2005
Member
72 hours and 150 GB

Regards.


Re: FRA size issue [message #264790 is a reply to message #264780] Tue, 04 September 2007 10:38 Go to previous messageGo to next message
sroy
Messages: 38
Registered: July 2005
Member
72 hrs and 150 gb.

regards.
Re: FRA size issue [message #264791 is a reply to message #264788] Tue, 04 September 2007 10:38 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

DB_RECOVERY_FILE_DEST_SIZE parameter value.

72 hours

What is ???

SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 0



Regards
Taj
Re: FRA size issue [message #264796 is a reply to message #264780] Tue, 04 September 2007 10:48 Go to previous messageGo to next message
sroy
Messages: 38
Registered: July 2005
Member
Sorry. I meant it to be db_flashback_retention_target. Ok, the value DB_RECOVERY_FILE_DEST_SIZE parameter is 260 gb.
Re: FRA size issue [message #264799 is a reply to message #264796] Tue, 04 September 2007 10:54 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Whats the rate of archive logs?
Whats the size of Archive logs?
Do you use Compress backup option?
why don't you move your backups to other machine after backup.
Re: FRA size issue [message #264802 is a reply to message #264796] Tue, 04 September 2007 10:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

db_flashback_retention_target
It is depands on you...there is no problem with 72 hrs.

and don't worry about FRA size. you should increase "db_recovery_file_dest_size" parameter to more size.

<quote>
DB_FLASHBACK_RETENTION_TARGET specifies the upper limit (in minutes) on how far back in time the database may be flashed back. How far back one can flashback a database depends on how much flashback data Oracle has kept in the flash recovery area.
</quote>

Re: FRA size issue [message #264808 is a reply to message #264780] Tue, 04 September 2007 11:14 Go to previous messageGo to next message
sroy
Messages: 38
Registered: July 2005
Member
Another question within the same thread...will rman auto delete the oldest backupsets (still within the retention policy) from the FRA after backing them up to the tape and still be able to know where they are when necessary for recovery? Otherwise, I will do the research.

Regards.
Re: FRA size issue [message #264809 is a reply to message #264808] Tue, 04 September 2007 11:20 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

RMAN delete all backupset, autobackup, archivelog file which are obsolete through retention policy.

when you add those line in your backup scripts.

DELETE NOPROMPT OBSOLETE;
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;


regards
Taj
Re: FRA size issue [message #264810 is a reply to message #264780] Tue, 04 September 2007 11:31 Go to previous messageGo to next message
sroy
Messages: 38
Registered: July 2005
Member
The backups are not obsolete or expired yet, and so, if we move them out to the other machine or backup those backups to the tape (sbt) in order to reduce the FRA space use, will rman be able to recover from them when necessary from the other machine or tape all by itself?
Re: FRA size issue [message #264811 is a reply to message #264810] Tue, 04 September 2007 11:33 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Yes you can use them laterz.But make sure you have all backup files.
Re: FRA size issue [message #264813 is a reply to message #264780] Tue, 04 September 2007 11:48 Go to previous messageGo to next message
sroy
Messages: 38
Registered: July 2005
Member
This leads me to another question for clarification. Does it mean we will have to manually delete the backups after successful backup to tape? Does rman allows us to move the backups out of the FRA?
Re: FRA size issue [message #264814 is a reply to message #264813] Tue, 04 September 2007 12:08 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Does rman allows us to move the backups out of the FRA?


Yes You can but before recovery you have to recopy it to same folder.

Quote:
Does it mean we will have to manually delete the backups after successful backup to tape?


Yes.
Re: FRA size issue [message #264815 is a reply to message #264780] Tue, 04 September 2007 12:14 Go to previous message
sroy
Messages: 38
Registered: July 2005
Member
Thank you all for sharing the info.
Previous Topic: DATA PUMP IMP & EXP
Next Topic: Test Server....
Goto Forum:
  


Current Time: Sat Dec 03 15:53:33 CST 2016

Total time taken to generate the page: 0.10000 seconds