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; }
2011 384 hackworth_ppt
View more  presentations from  Maclean Liu


本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1277864
相关文章
|
3月前
|
SQL Java Maven
flywa报错Migration checksum mismatch for migration version 1.1 -> Applied to database : 1332862643 ->
flywa报错Migration checksum mismatch for migration version 1.1 -> Applied to database : 1332862643 ->
42 1
|
安全 关系型数据库 RDS
2-minute Comparison of Online Database and Self-built Databases
Should you use Alibaba Cloud ApsaraDB for RDS or build your own database?
2247 0
|
SQL Oracle 关系型数据库
Data Migration Pre-Check Failures and Solutions
Alibaba Cloud Data Transmission Service supports data transmission between database-centered structured storage products.
2572 0