Exam 1z0-062 topic 1 question 336 discussion

Actual exam question from Oracle's 1z0-062

Question #: 336
Topic #: 1

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.)

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

Show Suggested Answer

Suggested Answer: BC 🗳️
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmtspit.htm#BRADV99978
If constraints for the tables in tablespace tbs1 are contained in the tablespace tbs2, then you cannot recover tbs1 without also recovering tbs2.

by Oracle2020 at July 20, 2021, 2:56 p.m.

Comments

Submit Cancel

Clozoerie

3 years, 9 months ago

BC Initially, your recovery set includes the data files for the tablespaces that you intend to recover. However, if objects in the tablespaces that you need have relationships (such as constraints) to objects in other tablespaces, then you must account for these relationships before you can perform TSPITR. You have the following choices when faced with such a relationship: - Add the tablespace including the related objects to your recovery set - Remove the relationship - Suspend the relationship for the duration of TSPITR

upvoted 4 times

...

Oracle2020

3 years, 10 months ago

I think is A, C

upvoted 2 times

jackymak

3 years, 2 months ago

The TSPITR need to perform in nomount mode. I think not A, should be B,C.

upvoted 1 times

...