Cloning a Database

Senior Oracle DBA, Sameer Wadhwa, gives 10 steps to cloning a database.

http://www.samoratech.com/TopicOfInterest/swCloneDB.htm

The 10 steps are:

The following steps must be on Source -Production instance/Server

Step 1.

Shutdown database in normal mode and start it up in restricted                                      mode.

Step 2.

Take the backup of control file

Step 3.

Shutdown database again  in normal mode.

Step 4.

Copy /FTP  init parameter file ,control file script  and all the                                      database file on the destination server/location, once all the files                                      are successfully copied, you may startup the database normally.

The following steps must be on destination – Clone instance/server

Step 5.

Edit init parameter file and control file script.

Step 6

.  New Environment setup .

Step 7.

Connect with svrmgrl and recreate control file

Step 8.

Open the database in resetlogs.

Step 9.

Shutdown the database in normal mode

Step 10

. Take the cold backup and start the database in archive/non                                           archive mode.

Gửi phản hồi

Please log in using one of these methods to post your comment:

WordPress.com Logo

Bạn đang bình luận bằng tài khoản WordPress.com Log Out / Thay đổi )

Twitter picture

Bạn đang bình luận bằng tài khoản Twitter Log Out / Thay đổi )

Facebook photo

Bạn đang bình luận bằng tài khoản Facebook Log Out / Thay đổi )

Google+ photo

Bạn đang bình luận bằng tài khoản Google+ Log Out / Thay đổi )

Connecting to %s