|
|
|
Clone an Oracle Database
编辑:IT小傻瓜 来源:intertnet 日期:2008-03-19 我要投稿
家园 |
|
Description
Need to create a duplicate database on the same machine ? Database too big to use Export/Import ?
This is the easiest way to do it.
Assume the original database is called PROD1 and you want to create a CLONE1 duplicate database.
Procedure
- Find some disk space and create appropriate directories / file systems for you cloned database (conforming to the OFA guidelines)
- Connect to the PROD1 instance and dump the controlfile using the SQL command
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
This will put a text copy of the controlfile in the USER_DUMP_DEST
- Shutdown Normal PROD1 database
- Perform an operating system copy of PROD1 to the new location where CLONE1 will reside.
- Startup the PROD1 instance
- Edit the controlfile you created and change all the path names of the database to the new location.
- Set your environment to the CLONE1 instance and run Server Manager (svrmgrl)
CONNECT INTERNAL
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE SET DATABASE "CLONE1" RESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 64
MAXINSTANCES 8
MAXLOGHISTORY 800
LOGFILE
GROUP 1 '/oracle/data/CLONE1/redos/log1CLONE1.dbf' SIZE 512K,
GROUP 2 '/oracle/data/CLONE1/redos/log2CLONE1.dbf' SIZE 512K,
GROUP 3 '/oracle/data/CLONE1/redos/log3CLONE1.dbf' SIZE 512K
DATAFILE
'/oracle/data/CLONE1/system_ts/systCLONE1.dbf' SIZE 25M,
'/oracle/data/CLONE1/data_ts/data_CLONE1.dbf' SIZE 230M,
'/oracle/data/CLONE1/index_ts/index_CLONE1.dbf' SIZE 230M,
'/oracle/data/CLONE1/rbs_ts/rbs_CLONE1.dbf' SIZE 10M,
'/oracle/data/CLONE1/temp_ts/temp_CLONE1.dbf' SIZE 10M,
'/oracle/data/CLONE1/tools_ts/ts_tools_CLONE1_02.dbf' SIZE 15M,
'/oracle/data/CLONE1/users_ts/ts_users_CLONE1.dbf' SIZE 1M,
;
ALTER DATABASE OPEN RESETLOGS;
- That's it, an exact duplicate of PROD1 and a painless procedure.
上一篇：常用数据库比较
下一篇：ORACLE Developer/2000 编程技巧
|
|
|
|
【文章评论】
【收藏本文】
【推荐好友】
【打印本文】
【论坛讨论】 |
 相关文章: |
|
 |
文章评论:(0条) |
|
|
|
|
责任编辑:IT学院 声明：刊登此文章是为了传递更多信息,文章内容仅供参考,转载请注明出处。 |
|
网站地图
收藏本站
高级搜索
