OraFAQ Forum: Backup & Recovery » FRA size issue

Home » RDBMS Server » Backup & Recovery » FRA size issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRA size issue [message #264780]

Tue, 04 September 2007 10:14

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?

Report message to a moderator

Re: FRA size issue [message #264782 is a reply to message #264780]

Tue, 04 September 2007 10:21

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

Report message to a moderator

Re: FRA size issue [message #264788 is a reply to message #264780]

Tue, 04 September 2007 10:36

sroy
Messages: 38
Registered: July 2005

Member

72 hours and 150 GB

Regards.

Report message to a moderator

Re: FRA size issue [message #264790 is a reply to message #264780]

Tue, 04 September 2007 10:38

sroy
Messages: 38
Registered: July 2005

Member

72 hrs and 150 gb.

regards.

Report message to a moderator

Re: FRA size issue [message #264791 is a reply to message #264788]

Tue, 04 September 2007 10:38

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

Report message to a moderator

Re: FRA size issue [message #264796 is a reply to message #264780]

Tue, 04 September 2007 10:48

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.

Report message to a moderator

Re: FRA size issue [message #264799 is a reply to message #264796]

Tue, 04 September 2007 10:54

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.

Report message to a moderator

Re: FRA size issue [message #264802 is a reply to message #264796]

Tue, 04 September 2007 10:56

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>

Report message to a moderator

Re: FRA size issue [message #264808 is a reply to message #264780]

Tue, 04 September 2007 11:14

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.

Report message to a moderator

Re: FRA size issue [message #264809 is a reply to message #264808]

Tue, 04 September 2007 11:20

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

Report message to a moderator

Re: FRA size issue [message #264810 is a reply to message #264780]

Tue, 04 September 2007 11:31

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?

Report message to a moderator

Re: FRA size issue [message #264811 is a reply to message #264810]

Tue, 04 September 2007 11:33

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Yes you can use them laterz.But make sure you have all backup files.

Report message to a moderator

Re: FRA size issue [message #264813 is a reply to message #264780]

Tue, 04 September 2007 11:48

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?

Report message to a moderator

Re: FRA size issue [message #264814 is a reply to message #264813]

Tue, 04 September 2007 12:08

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.

Report message to a moderator

Re: FRA size issue [message #264815 is a reply to message #264780]

Tue, 04 September 2007 12:14

sroy
Messages: 38
Registered: July 2005

Member

Thank you all for sharing the info.

Report message to a moderator

Previous Topic:	DATA PUMP IMP & EXP
Next Topic:	Test Server....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 04:04:19 CDT 2024