There are some alternatives to use when you perform incomplete recovery. If you use Enterprise Manager media recovery options, you may add
in front of the
command. To make Oracle automatically apply redo log files during recovery, there are two methods:
AUTO at the recovery prompt
- Use the command
Incomplete recovery is a difficult operation. Experience shows that most problems that occur in the process are caused by DBA errors.
Thus, it is essential to carefully follow the recovery steps demonstrated in the View SlideShow below.
You may also preview
all the steps.
As a DBA, you should also make sure the objects are recovered before you make the database available to your users. You may, for example, query the user's schema to check that the supposedly recovered objects exist. If they do not, you have to repeat the recovery process again.