• [bbk5255] 第119集 第15章 数据库复制 03


    复制数据库,采用目标数据库的备份可以进行;

    Active source database ---> TCP/IP ---> Destination or AUXILIARY database

    Duplicating a Database

    • With network(no backups required)
    • Including customized spfile
    • Via Enterprise Manager or RMAN command line

    Performing Active Database Duplication

    The RMAN DUPLICATE Command

    采用命令行方式克隆数据库语法

    DUPLICATE TARGET DATABASE
    
      TO dbtest
    
      FROM ACTIVE DATABASE
    
    SPFILE PARAMETER_VALUE_CONVERT '/u01','/u02'      
        SET SGA_MAX_SIZE = '200M'
        SET SGA_TARGET = '125M'
        SET LOG_FILE_NAME_CONVERT = '/u01','/u02'
        SET DB_FILE_NAME_CONVERT = '/u01','/U02';

    Dupliating an Active Database

    1. Create an Oracle password file for the auxiliary instance.
    2. Establish Oracle Net connectivity to the auxiliary instance.
    3. Create an initialization parameter file for the auxiliary instance.
    4. Start the auxiliary instance in NOMOUNT mode.
    5. Mount or open the target database.
    6. Allocate auxiliary channels if needed.
    7. Execute the DUPLICATE command.

    Quiz

    Select all statements that are true about database duplication:

    1. You can duplicate a database with or without connection to the auxiliary instance.
    2. You can duplicate a database with or without connection to the recovery catalog.
      1. 可以没有目录数据库
    3. You can duplicate a database with or without target connection.
    4. You can duplicate a database only when you have RMAN backups.
      1. 当数据库处于active状态时,也可以duplicate操作.
    5. You alwarys have to manually re-create control files on the auxiliary instance.
  • 相关阅读:
    PB笔记之导入、导出组件
    pb笔记之数据窗口设置操作
    PB笔记之第一行数据不能删除的解决方法
    PowerBuilder学习笔记之行删除卡死问题
    PB笔记之数据窗口行不能编辑的原因
    PB笔记之导出为Excel的方法
    PowerBuilder学习笔记之导入Excel数据
    PB笔记之数据窗口添加虚拟列的方法
    PowerBuilder学习笔记之调用事件和函数
    Apache按日切分日志
  • 原文地址:https://www.cnblogs.com/arcer/p/3130546.html
Copyright © 2020-2023  润新知