[bbk5241] 第116集 -第15章 - 数据库复制 00

Objectives

After completing this lesson,you should be able to :

• List the purpose of creating a duplicate database.
• Choose a technique for duplicating a database.
• Duplicate a database with RMAN
• Use an RMAN backup to duplicate a database
• Duplicate a database based on a running instance

Using a Duplicate Database

• Using a duplicate database to :
  • Test backup and recovery procedures
  • Recover objects by creating an export and importing the objects into the production database.
• Creating a duplicate database:
  • With the RMAN DUPLICATE command
  • On the same or separate hosts
  • With the identical content,or subset of source
  • Performed by auxiliary channels for back-up based duplication
  • Performed by target channels for active database duplication.

Choosing Database Dupliating Techniques

Choosing a technique to duplicate your database -- always with connection to the auxiliary instance:

Duplicating an Active Database

通过这种方式，可以克隆出最新的数据库来

• With newwork(no backups required)
• Including customized SPFILE
• Via Enterprise Manage or RMAN command line

Duplicating a Database with a Target Connection

通过这种方式，可以基于备份信息进行数据库的克隆.

• Connecting to the target(source database)
• Connecting to the auxiliary instance
• Optionally,connecting to the recovery catalog(or using target control file)

Duplicating a Database with Recovery Catalog without target connection

• Connecting to a recovery catalog for backup metadata
• Connecting to the auxiliary instance,which must have access to the RMAN backups

Duplicating a Database Without Recovery catalog or target connection

Connecting to the auxiliary instance,which must have a access to a disk BACKUP LOCATION