oracle10g/11g 新特性十三(数据库复制)

Choosing Database Duplication Techniques

creating a duplicate database  for active database duplication  (oracle 11g 功能)

Duplicating an Active Database

Duplicating a Database with a Target Connection

Duplicating a Database with Recovery Catalog Without Target Connection

Duplicating a Database Without Recovery Catalog or Target Conection

Creating a Backup-Based Duplicate Database

1.Create an Oracle password file for the auxiliary instance

2.Establis Oracle Net connectivity to the auxiliary instance

3.Create an initialization parameter file for the auxiliary instance

4.Start the auxiliary instance in NOMOUNT node

5.Mount or open the target database

6.Ensure that backups and archived redo log files are avaliable

7.Allocate auxiliary channels if needed

8.Execute the DUPLICATE command

Creating an Initialization Parameter File for the Auxiliary Instance

Specify parameter as follows:

 DB_NAME : if the duplicate database is in the same Oracle home as the target database, naes must be different.

                     Use the same value in the DUPLICATE command

DB_BLOCK_SIZE: Specify the same values as set for the target database

Specifying New Names for Your Destination

Available techniques:

 1.Set NEWNAME command

 2.CONFIGURE AUXNAME command(deprecated for recovery set data files)

 3.DB_FILE_NAME_CONVERT parameter with the DUPLICATE command

Specifying Parameters for File Naming

Using the SET NEWNAME Clauses

Substitution Variables for set NEWNAME

Starting the Instance in nomount Mode

Ensuring That backups and Archived Redo log Files Are Available

Allocating Auxiliary Channels

Understanding the Rman duplication operation

Specifying Options for the DUPLICATE Command

Duplicating a Database

如果在线克隆， target数据库需要在归档模式下,如果是mount 模式下， target必须是干净的关闭

The RMAN  DuPLICATE Command

Duplicating an Active Database