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