复制数据库,采用目标数据库的备份可以进行;
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
- Create an Oracle password file for the auxiliary instance.
- Establish Oracle Net connectivity to the auxiliary instance.
- Create an initialization parameter file for the auxiliary instance.
- Start the auxiliary instance in NOMOUNT mode.
- Mount or open the target database.
- Allocate auxiliary channels if needed.
- Execute the DUPLICATE command.
Quiz
Select all statements that are true about database duplication:
- You can duplicate a database with or without connection to the auxiliary instance.
- You can duplicate a database with or without connection to the recovery catalog.
- 可以没有目录数据库
- You can duplicate a database with or without target connection.
- You can duplicate a database only when you have RMAN backups.
- 当数据库处于active状态时,也可以duplicate操作.
- You alwarys have to manually re-create control files on the auxiliary instance.