Home » RDBMS Server » Backup & Recovery » FRA maintenance with Flashback on, but no RMAN backup (Linux)
FRA maintenance with Flashback on, but no RMAN backup [message #672442] Mon, 15 October 2018 11:22 Go to next message
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.
Re: FRA maintenance with Flashback on, but no RMAN backup [message #672443 is a reply to message #672442] Mon, 15 October 2018 11:44 Go to previous messageGo to next message
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.
Re: FRA maintenance with Flashback on, but no RMAN backup [message #672444 is a reply to message #672442] Mon, 15 October 2018 13:01 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: FRA maintenance with Flashback on, but no RMAN backup [message #672447 is a reply to message #672442] Mon, 15 October 2018 14:15 Go to previous messageGo to next message
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.
Re: FRA maintenance with Flashback on, but no RMAN backup [message #672497 is a reply to message #672447] Tue, 16 October 2018 10:58 Go to previous message
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.
Previous Topic: Formatting TAG in rman scripts
Next Topic: relink ORACLE_HOME with EXPORT process
Goto Forum:
  


Current Time: Thu Mar 28 12:57:36 CDT 2024