PERFORM INCOMPLETE RECOVERY WITH RMAN, USING A BACKUP CONTROLFILE IN THIS EXERCISE, WHICH CONTINUES FROM 3, YOU WILL DROP A TABLESPACE AND THEN PERFORM AN INCOMPLETE RECOVERY TO A TIME JUST BEFORE IT WAS DROPPED

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