Performing Oracle User-Managed Database Recoveries - OCP: Oracle Database 12c Administrator Certified Professional - page 59

The process is simple. You copy all the files you backed up during your offline backup
(data files, control files, redo logs) and then start the database. You simply must copy all of
these files; you can't pick and choose what to recover. Exercise 2.1 provides an example
of such a recovery operation.

e xeRCiSe 2.1

Restoring a Database Using a Cold Backup

In this exercise, you will be restoring the database with a cold backup. It is assumed the
database is in NOARCHIVELOG mode.

1. Make sure the database is shut down.

2. Copy the files on the backup media to the original location. You would copy the
following files:

Database data files

■

Database control files

■

Database online redo logs

■

If the original location of the database files is not available, copy them to an alternate
location. Having copied the files to an alternate location, you will likely need to execute
an optional step 3 for the control files and optional step 4 for all database files and/or
online redo logs. Here is an example of the COPY command:

C:\Documents and Settings\Robert>copy c:\oracle\oradata\orcl\cold\*.*
c:\backup\orcl\backup1

3. (Optional) If you copied the database control files to a location other than their original
location, you will need to modify the database parameter CONTROL_FILES to point to
the control files in their new location.

If you are using a text-based parameter file (pfile), simply edit the file and change the
CONTROL_FILES parameter value contained within that file

If you are using a server-based parameter file (spfile), then you will need to start the
database in NOMOUNT mode and change the SPFILE entry for the CONTROL_FILES
parameter using the ALTER SYSTEM command. You will have to use the SCOPE=SPFILE
keyword when issuing the ALTER SYSTEM command since changing the CONTROL_
FILES parameter is not supported as a dynamic change.

After you have changed the parameter file (manually or using the ALTER SYSTEM
command), use the SHUTDOWN command to shut down the database (the parameter
file will be reread when you open it again in the next steps). Here is an example:

SQL> startup nomount
ORACLE instance started.
Total System Global Area 397557760 bytes