1Z0-083 practice question 26 of 35

Choose four. Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

Full set: 286 questions
Answer options
A: It can be performed using an auxiliary instance managed by RMAN. Correct answer
B: It can be performed using an auxiliary instance managed by a DBA.
C: It can be used to recover a truncated table. Correct answer
D: It can be performed repeatedly until the correct time is found without using an RMAN catalog. E)RMAN always includes tablespaces containing UNDO segments in the recovery set.
E: RMAN automatically adds any required tablespaces to the recovery set to make it selfcontained. G) FLASHBACK DATABASE must be enabled for it to work. H) It can be used to recover a dropped tablespace.
Correct Answer:
A. It can be performed using an auxiliary instance managed by RMAN.; C. It can be used to recover a truncated table.
Explanation

Tablespace Point-in-Time Recovery (TSPITR) is a powerful RMAN feature. The standard and automated method involves RMAN creating and managing an auxiliary instance to perform the recovery of the tablespace(s) to a temporary location before exporting metadata and plugging the recovered tablespace back into the target database (A). TSPITR is a common solution for recovering from logical errors, such as a TRUNCATE TABLE statement, by restoring the entire tablespace to a point in time before the operation occurred (C).

Why Incorrect

B: The "using RMAN" part of the question implies using RMAN's automated features, which manage the auxiliary instance, not a DBA doing it manually. D: Performing TSPITR more than once on the same tablespace requires the use of a recovery catalog to store the history of past TSPITR operations. E: RMAN automatically detects if the recovery set is not self-contained and reports an error; it does not automatically add the required tablespaces. G: TSPITR is a media recovery-based feature that uses backups and redo logs; it does not require Flashback Database to be enabled. H: A dropped tablespace cannot be recovered using TSPITR because its metadata is removed from the control file. A full database point-in-time recovery is required.

References

1. Oracle Database Backup and Recovery User's Guide, 19c. Chapter 17, "Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)". Section "About RMAN TSPITR". (Covers A, C, H).

2. Oracle Database Backup and Recovery User's Guide, 19c. Chapter 17, "Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)". Section "Planning and Preparing for RMAN TSPITR". (Covers E).

3. Oracle Database Backup and Recovery User's Guide, 19c. Chapter 17, "Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)". Section "Performing RMAN TSPITR with a Recovery Catalog". (Covers D).

Scroll to Top