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 questionsTablespace 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).
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.
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).
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
