Recovering Databases with RMAN - OCP: Oracle Database 12c Administrator Certified Professional - page 195

options, including tablespace point-in-time recovery, are also available. These are covered
in Chapter 6 of this topic.
Complete recovery is called for when all or most of the data files of the database have
been lost. Tablespace or data file recovery is a better solution if you have lost only a few data
files or perhaps all data files of one or two tablespaces. Let's look at each of these recovery
methods in more detail next.
Complete Database Recovery in ARCHIVELOG Mode
A complete database recovery in ARCHIVELOG mode is required when most or all of
the database data files have been lost. In this mode, the database is shut down (if it has not
already done so itself because of the loss of data files). It is then mounted and recovered.
Here are the steps to follow for a complete database recovery in ARCHIVELOG mode:
1. Shut down the database if it is not already down.
2. If you have lost your control file or spfile, you will need to reference the section
“Other Basic Recovery Topics,” which appears later in this chapter. To start any
RMAN recovery, you must have a control file and an spfile or parameter file.
3. If you are not already logged into RMAN (for example, if you had to restore your
control file), then log into RMAN now.
4. Mount your database with the STARTUP MOUNT command.
5. Issue the RMAN RESTORE DATABASE command.
6. Issue the RMAN RECOVER DATABASE command. The command will restore the
needed incremental backups and archived redo logs, recovering the database to
the point of failure.
7. Open the database with the ALTER DATABASE OPEN command. If you restored your
control file, you will need to use the ALTER DATABASE OPEN RESETLOGS command.
Here is an example of a recovery in ARCHIVELOG mode:
RMAN> shutdown abort
using target database control file instead of recovery catalog
Oracle instance shut down
RMAN> startup mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 397557760 bytes
Fixed Size 1333452 bytes
Variable Size 339740468 bytes
Database Buffers 50331648 bytes
Redo Buffers 6152192 bytes
RMAN> restore database;
Starting restore at 28-SEP-13