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.
 |
|
Need an Oracle Health Check?
- Do you have
bad performance after an upgrade?
- Need to
certify that your database follows best practices?
BC Oracle performance gurus can quickly
certify every aspect of your
Oracle database and provide a complete verification that your database
is fully optimized. |
|
|
