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
相关文章
|
5月前
|
数据库 开发工具 开发者
【Python】已解决:You have 18 unapplied migration(s). Your project may not work properly until you apply t
【Python】已解决:You have 18 unapplied migration(s). Your project may not work properly until you apply t
223 0
|
7月前
|
安全
AWR Data in a Multitenant Environment
AWR Data in a Multitenant Environment
25 1
This job is stuck, because the project doesn‘t have any runners online assigned to it. Go to Runners
This job is stuck, because the project doesn‘t have any runners online assigned to it. Go to Runners
This job is stuck, because the project doesn‘t have any runners online assigned to it. Go to Runners
|
Java Shell PHP
Guidelines for Function Compute Development - Use Fun Local for Local Running and Debugging
Preface The following key concepts are involved in this document: Function Compute: an event-driven service that allows you to focus on writing and .
1785 0
Why Your Dev/Test Environment is as Important as Production
Development and Testing, although important, are often overlooked in a software delivery cycle.
1492 0