Exercise 16-5: Perform Incomplete Recovery with RMAN, Using a
Backup Controlfile In this exercise, which continues from Exercise 16-3, you
will drop a tablespace and then perform an incomplete recovery to a time just before
it was dropped. This is possibly the most complex operation that may ever be
necessary. It must be performed in several stages: first a version of the controlfile that
dates from the time the tablespace existed must be restored, and the database must be
mounted with this controlfile. Only then can the rest of the database be restored and
recovered.
Before launching RMAN or SQL*Plus, ensure that your operating system date
format is set to a known value. For example, on Windows:
set NLS_DATE_FORMAT=dd-mm-yy hh24:mi:ss
Bạn đang xem exercise 16- - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P67 PPS