Databases Reference
In-Depth Information
In the prior output, the file starting with “c-“ is the backup piece that contains the control file. You'll have to
inspect the output of your
list backup
command to determine which backup piece contains the control file. You'll
need to reference that backup piece in step 8.
Step 2: Copy RMAN Backup to Destination Server
For this step, use a utility such as
rsync
or
scp
to copy the backup pieces from one server to another. This example
uses the
scp
command to copy the backup pieces:
$ scp 1* oracle@DEVBOX:/ora01/rman/DEVDB
$ scp c-* oracle@DEVBOX:/ora01/rman/DEVDB
In this example, the /ora01/rman/DEVDB directory must be created on the destination server before copying the
backup files. Depending on your environment, this step might require copying the RMAN backups twice; once from
the production server to a secure server and from the secure server to a test server.
■
if the rman backups are on tape instead of on disk, then the same media manager software must be
installed/configured on the destination server. also, that server must have direct access to the rman backups on tape.
Note
Step 3: Ensure that Oracle Is Installed
Make sure you have the same version of Oracle binaries installed on the destination as you do on the originating database.
Step 4: Source the Required OS Variables
You need to establish the operating system variables, such as ORACLE_SID, ORACLE_HOME, and PATH. Initially,
we usually set the ORACLE_SID variable to match what it was on the original database. The database name will be
changed as part of the last step in this recipe (optional). Here are the settings for ORACLE_SID and ORACLE_HOME
on the destination server:
$ echo $ORACLE_SID
o12c
$ echo $ORACLE_HOME
/ora01/app/oracle/product/12.1.0.1/db_1
Step 5: Create an init.ora File for the Database to be Restored
Copy the init.ora file from the original server to the destination server and modify it so that it matches the destination
box in terms of any directory paths. For example, make sure you modify the
control_files
parameter so that the path
names reflect where the control files will be placed on the new server.
