Oracle Database 12c: Installation and Administration — Question 168

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS. Which two actions will permit the TSPITR to work? (Choose two.)

Answer options

• A. Taking the MASTERTBS tablespace offline
• B. Dropping the relationship between the tables
• C. Adding the MASTERTBS tablespace to the recovery set
• D. Putting the MASTERTBS tablespace in read-only mode

Correct answer: B, C

Explanation

Option B is correct because removing the relationship between the tables allows TSPITR to proceed without dependency issues. Option C is also correct since adding the MASTERTBS tablespace to the recovery set ensures that all necessary data for the referential integrity is included in the recovery process. The other options, A and D, do not address the need for referential integrity and would not facilitate a successful TSPITR.