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;
}

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569