Clone an Oracle Database

王朝oracle·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

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.

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航