To quote from RinD's link, it specifically states that ABCE are wrong:
22.1.4 Limitations of Recovering Tables and Table Partitions from RMAN Backups
Recovering tables and table partitions from RMAN backups by using the RECOVER command is subject to certain limitations.
The limitations include the following:
Tables and table partitions belonging to SYS schema cannot be recovered.
Tables and table partitions from SYSTEM and SYSAUX tablespaces cannot be recovered.
Tables and table partitions on standby databases cannot be recovered.
So, DFG definitely correct.
A. RMAN can recover tables in the SYSAUX tablespace. - WRONG
B. RMAN can recover tables owned by the SYS user. - WRONG
C. RMAN can recover tables in the SYSTEM tablespace.- WRONG
D. RMAN always uses an auxiliary instance.
E. RMAN can recover tables in a standby database.- WRONG
F. RMAN can recover a table after a DDL operation has altered the table structure.
G. RMAN can recover tables owed by the SYSTEM user.
22.1.4 Backup Guide
DFG -Correct
Performing Table and Partition Recovery from Backups
There are some restrictions related to table and partition-level recoveries. These include
the following:
■ You cannot restore tables that belong to the SYS schema.
■ Tables that are stored in the SYSTEM and SYSAUX tablespaces cannot be restored.
■ Tables and table partitions in standby databases cannot be restored.
■ If a table to be restored has a NOT NULL constraint assigned to it, then you can’t use the
REMAP option of the RECOVER TABLE command.
DFG
The limitations include the following:
Tables and table partitions belonging to SYS schema cannot be recovered.
Tables and table partitions from SYSTEM and SYSAUX tablespaces cannot be recovered.
Tables and table partitions on standby databases cannot be recovered.
Tables with named NOT NULL constraints cannot be recovered with the REMAP option.
see https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-recovering-tables-partitions.html#GUID-526969ED-37C3-44C6-B205-AF1621008DCE
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
RinD
Highly Voted 3 years, 9 months agosaserdi
3 years, 7 months agoxRodge
3 years, 6 months agoAldrid
Highly Voted 3 years, 8 months agoErickZc
Most Recent 5 months, 2 weeks agoantonica
10 months, 1 week agoantonica
10 months, 1 week agokaka321
1 year, 6 months ago_gio_
1 year, 7 months agoScottL
1 year, 9 months agovkra
1 year, 11 months agonavingupta52
3 years, 7 months ago