• [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.
  • 相关阅读:
    20201220第二周学习总结
    师生关系
    快速浏览教材
    学期2020-2021-1学号20201220《信息安全专业导论》第1周学习总结
    编程将字符串s倒序输出,要求利用函数递归实现
    小学生四则运算随机生成程序
    礼炮问题
    C语言最大公约数
    C语言判断三角形类型
    C语言:一元二次方程解的所有情况
  • 原文地址:https://www.cnblogs.com/arcer/p/3130546.html
Copyright © 2020-2023  润新知