OraFAQ Forum: Backup & Recovery » FRA maintenance with Flashback on, but no RMAN backup

Home » RDBMS Server » Backup & Recovery » FRA maintenance with Flashback on, but no RMAN backup (Linux)

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

FRA maintenance with Flashback on, but no RMAN backup [message #672442]

Mon, 15 October 2018 11:22

dhu1
Messages: 2
Registered: October 2018

Junior Member

I am asked to configure a database similar as the following:

alter system set db_recovery_file_dest=' /flashback_recovery_area/testdb'
alter system set db_recovery_file_dest_size=2G;
alter system set db_flashback_retention_target = 4320;
alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST' ;
alter system alter database flashback on;

The database will not be backed up by RMAN, and archive logs will be only on FRA, We hope FRA could auto delete archive and flashback logs according to flashback_retention policy.

I wonder if it will work as expected with archive logs.

Thanks for help.

Report message to a moderator

Re: FRA maintenance with Flashback on, but no RMAN backup [message #672443 is a reply to message #672442]

Mon, 15 October 2018 11:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Some, many, most Professional IT folks would actually test to observe the results first hand instead of relying upon anonymous strangers.

Report message to a moderator

Re: FRA maintenance with Flashback on, but no RMAN backup [message #672444 is a reply to message #672442]

Mon, 15 October 2018 13:01

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

No. Flashback_retention_target is not relevant to removing archive logfiles.

And an aside - you are probably not going to get three days of flashback capability in a 2GB fast recovery area.

Report message to a moderator

Re: FRA maintenance with Flashback on, but no RMAN backup [message #672447 is a reply to message #672442]

Mon, 15 October 2018 14:15

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

dhu1 wrote on Mon, 15 October 2018 11:22

I am asked to configure a database similar as the following:

<snp>

The database will not be backed up by RMAN,

THen you must consider it a disposable, throw-away database, with no impact when (not"if") it is lost.

Quote:

and archive logs will be only on FRA, We hope FRA could auto delete archive and flashback logs according to flashback_retention policy.

Even more bizarre. You are running in archivelog mode, but no rman backups. And thus no way of performing housekeeping on your worthless archivelogs to prevent the FRA from filling up.

Report message to a moderator

Re: FRA maintenance with Flashback on, but no RMAN backup [message #672497 is a reply to message #672447]

Tue, 16 October 2018 10:58

dhu1
Messages: 2
Registered: October 2018

Junior Member

Thanks for the input.

For the storage issue, we just don't want backup many uncritical databases, but still want to flashback to the point-in-time, the idea is not feasible,we gave up.

Report message to a moderator

Previous Topic:	Formatting TAG in rman scripts
Next Topic:	relink ORACLE_HOME with EXPORT process

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 12:08:00 CST 2024