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

Overview of setup and configuration

• Oracle Enterprise Edition 11gR2. 11.2.0.1.0 Linux RH5 NetBackup 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; }

2011 384 hackworth_ppt

View more presentations from Maclean Liu