PrepAway - Latest Free Exam Questions & Answers

which are currently missing from the database are correctly applied to the database and that table space TS1 i

Due to an application error, some data was deleted from a very large table residing in table space
TS1. The table space was then renamed TS2 before the error was detected. Rather than try and
rebuild this table, it was decided that database DB1 would be restored and then rolled forward to a
point-in-time (PIT) before the delete operation took place. Unfortunately the PiT roll forward was
done to a time that was too early and some critical transactions were missing when the database
was brought back on-line. Which steps must be taken to ensure that the critical transactions which
are currently missing from the database are correctly applied to the database and that table space
TS1 is renamed TS2?

PrepAway - Latest Free Exam Questions & Answers

A.
1. Restore database DB1.
2. Roll forward to the correct point-in-time.
3. Rename TS1 to TS2.

B.
1. Restore table space TS1 from the DB1 backup image.
2. Roll forward to the correct point-in-time.
3. Rename table space TS1 to TS2.
4. Re-run the batch processes.

C.
1, Restore database DB1
2. Roll forward to end of logs.

D.
1. Restore table space TS1 from the DB1 backup image.
2. Roll forward to end of logs.


Leave a Reply