oracle10g/11g 新特性十三(数据库复制)
来源:互联网 发布:360浏览器有mac版的吗 编辑:程序博客网 时间:2024/06/06 06:57
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
- oracle10g/11g 新特性十三(数据库复制)
- oracle10g/11g 新特性六(数据库维护)
- oracle10g/11g 新特性九(数据库诊断)
- oracle10g/11g 新特性十二(数据库空间管理)
- oracle10g/11g 新特性一(ASM)
- oracle10g/11g 新特性二(Flashback Database)
- oracle10g/11g 新特性三(Flashback Table)
- oracle10g/11g 新特性四(管理内存)
- oracle10g/11g 新特性五(用Shceduler自动化)
- oracle10g/11g 新特性七(性能维护)
- oracle10g/11g 新特性八(SQL性能调优)
- oracle10g/11g 新特性十(数据移植)
- oracle10g/11g 新特性十一(表空间管理)
- Oracle 11g新特性之 - 使用RMAN复制数据库-视频分享
- Oracle 数据库 11g新特性:安全性
- Oracle 数据库 11g新特性:安全性
- 11g新特性
- 11g 新特性
- Effective C++笔记 条款18
- PHP与Mysql的连接
- Bugzilla安装过程
- mysql数据库查询find_in_set('3', field)
- My Eclipse常用设置和操作方法
- oracle10g/11g 新特性十三(数据库复制)
- 安卓cmd命令整理系列
- 【IPC通信】基于管道的popen和pclose函数
- 去掉UISearchBar自带的的边框背景
- 笔记本光驱拆解——让整个世界变得安静
- 优化数据页面(14)——表题的描述
- 命令
- Git解决fatal: unable to connect to github.com
- c语言开发错误集