• [bbk5241] 第116集 第15章 数据库复制 00


    Objectives

    After completing this lesson,you should be able to :

    • List the purpose of creating a duplicate database.
    • Choose a technique for duplicating a database.
    • Duplicate a database with RMAN
    • Use an RMAN backup to duplicate a database
    • Duplicate a database based on a running instance

    Using a Duplicate Database

    • Using a duplicate database to :
      • Test backup and recovery procedures
      • Recover objects by creating an export and importing the objects into the production database.
    • Creating a duplicate database:
      • With the RMAN DUPLICATE command
      • On the same or separate hosts
      • With the identical content,or subset of source
      • Performed by auxiliary channels for back-up based duplication
      • Performed by target channels for active database duplication.

    Choosing Database Dupliating Techniques

    Choosing a technique to duplicate your database -- always with connection to the auxiliary instance:

    Duplicating an Active Database

    通过这种方式,可以克隆出最新的数据库来

    • With newwork(no backups required)
    • Including customized SPFILE
    • Via Enterprise Manage or RMAN command line

    Duplicating a Database with a Target Connection

    通过这种方式,可以基于备份信息进行数据库的克隆.

    • Connecting to the target(source database)
    • Connecting to the auxiliary instance
    • Optionally,connecting to the recovery catalog(or using target control file)

    Duplicating a Database with Recovery Catalog without target connection

    • Connecting to a recovery catalog for backup metadata
    • Connecting to the auxiliary instance,which must have access to the RMAN backups

    Duplicating a Database Without Recovery catalog or target connection

    Connecting to the auxiliary instance,which must have a access to a disk BACKUP LOCATION

  • 相关阅读:
    poj 4005 Moles
    牛客 2C 圈圈
    牛客 2B 树 (组合计数)
    AC日记——校门外的树(增强版) 洛谷 P1276
    AC日记——寻找道路 洛谷 P2296
    AC日记——挤牛奶 洛谷 P1204
    AC日记——最大数 洛谷 P1198 [JSOI2008]
    AC日记——中位数 洛谷 P1168
    AC日记——校门外的树 洛谷 P1047
    AC日记——约瑟夫问题 codevs 1282
  • 原文地址:https://www.cnblogs.com/arcer/p/3130474.html
Copyright © 2020-2023  润新知