Wednesday, June 09, 2010

Oracle Database Cloning using Cold Backup

Steps to clone an Oracle Database (File System Based) using cold backup.
1.Shutdown the source database

2.Backup the datafiles.

3.Copy the datafiles to destination location.

4.Execute the command 'alter database backup controlfile to trace' from the source database.

5.Rename this file to create_db.sql

6.Modify the file for the following:
6.1 Remove the contecnt under NoResetlog Section.
6.2 Rename the work reuse to set
6.3 Update the Database Name
6.4 Comment the commands - RECOVER DATABASE USING ....
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TEMP ADD TEMPFILE
6.5 Modify the datafile locations in this file so as to reflect the new location in destination database.
7.Copy the initSID.ora file from the source and to destination location and modify it contents for new database.
8.At the destination location, set the oracle home and oracle sid parameters
9.Connect as Sysdba and execute the create_db.sql script.
10.Once the control file is created ,execute the command 'alter database open resetlogs;'
11.Bounce the database once and it is ready for use.

No comments: