Database Backup and Recovery (MOSC)

MOSC Banner

autobackup control and spfile not going to FRA

edited Dec 21, 2023 6:14PM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓

Oracle SE2 Version 19.21.0.0 Refer to the attached text file below.

Incarnation list is at top.

BS KEY 4 and 8 are prior to going to archivelog mode, and are a cold backup.

BS KEY 9, 10, 11, and 12 were produced by the first rman backup run in archivelog mode, and were run using the parameters which follow.

The rman run block which produced the backup is at the bottom.

My backup is about 5.5GB more or less. My FRA is capable of 100GB, but is currently set at 25GB. I wish to keep 3 days of backups.

Questions:

  1. Why did additional files end up in /u01/app/oracle/product/19.0.0/dbhome_1/dbs/ instead of in the FRA like #8? No files ended up in FRA autobackup for the archivelog backup. I reset all of the RMAN configuration parameters between those two backups, but CONFIGURE SNAPSHOT CONTROLFILE NAME TO '%F' did not change.

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