Database Administration (MOSC)

MOSC Banner

Archivelogs deletedion from the FRA issue

Dood day,

I am performing PITR, so I created a clone of a production DB (Oracle 19.11) and now I want to recover it to a point in time, so I am restoring archivelogs. My issue is that during restore archivelogs are automatically deleted by the database. I changed archivelog destination to another diskgroup in ASM (rman command set archivelog destination to), but it did not help. I found a note Archivelogs Are Being Automatically Deleted From The FRA Even Though There Is No Space Pressure (Doc ID 1377765.1) and this is my case - RECORDS_TOTAL=RECORDS_USED in V$CONTROLFILE_RECORD_SECTION , but note just says that this is an expected behaviour . Note meintions parameter control_file_record_keep_time , playing with parameter value did not help. There is an event 19823 which changes default deletion policy, but playing with event also did not work.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center