Restore Production Database to Development Platform A step-by-step example

Overview of setup and configuration

• Oracle Enterprise Edition 11gR2. 11.2.0.1.0Linux RH5NetBackup 6.5.5
• Identical environments:
• Identical versions of Oracle.
• Same ORACLE_HOME and ORACLE_BASE.
• The archive log directory is defined to be the Flash Recovery Area:
• You know the DBID.
• Control file autobackup feature enabled with the default format.

NetBackup MML considerations

Restoring from tape using the NetBackup MML
MANDITORY requirement on the NetBackup Master Server.

On the NBU Master server the following directory and file must exist:
/[netbackup install]/db/altnames/No.Restrictions

Restore

Restore the spfile to pfile.

RMAN> run {
allocate channel t1 device type sbt;
send ‘NB_ORA_SERV=NBU_MasterServer.com, NB_ORA_CLIENT=Original_Client.com’;
set controlfile autobackup format for device type sbt to ‘%F’;
restore spfile
to pfile ‘?/dbs/initprod.ora’
from autobackup;
shutdown abort;
}