[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.