Q: 8
Which three are true about using RMAN in a Data Guard environment?
Options
Discussion
I'm thinking C makes sense since recovery catalogs are often needed when moving backups between primary and standby. Maybe I'm missing something, but the docs seem to lean that way. Anyone see cases where A or B fits better?
A B, D tbh. Archived redo and datafile backups from standby can be used on primary, but not control file backups. Oracle docs mention this, but if anyone's seen a different behavior in newer releases let me know.
Not sure B is right. Thought standby control file backups could be used on the primary as well unless there’s some subtlety in the format. Maybe I’ve got that mixed up with datafile and log backups, anyone see this tested differently?
Its A, B, D. Pretty sure Oracle's official docs and practice exams highlight that datafile and archived redo log backups are swappable between physical standby and primary, but not control file backups. If you want extra confidence, check the official guide or practice test just to be safe.
Hard to say, C , pretty sure a recovery catalog is needed for backup/restore between standby and primary.
Option A B, D. Primary and physical standby can share datafile and redo log backups, not control file backups.
Why does B say control file backups from standby can't be used on primary? Wouldn't format and compatibility allow interchange?
A. B, D tbh. RMAN treats archived redo and datafile backups as interchangeable but not control file backups between primary and standby. Pretty sure that's what Oracle recommends, but correct me if I missed some new change.
C or E. I remember reading that a recovery catalog is needed for some standby backup scenarios, but can't recall which exactly. Might be mixing up logical and physical standby rules here, so not totally sure.
Probably A, B, D. Archived logs and datafile backups from physical standby are valid on primary, but control file backups aren't interchangeable. Seen this split called out in Oracle docs too. Not 100% if anyone's run into a weird case though.
Be respectful. No spam.