Easy, Efficient & Quick Oracle Cloning!!

 Author: Larry Catt

Page: 1 2

Every database administrator at some point needs to transport their entire database from one location to another. There can be any reason behind cloning Oracle database such as its relocation to another machine, renaming Oracle database or moving your Oracle database to a new storage media. Whatever the reason may be but you are required to accomplish this task easily, efficiently, correctly and in less time.

Oracle 10g has made the life of DBAs easy by providing Oracle database Creation Assistant but this feature is somehow annoying for especially novice Oracle DBAs. In this article we will discuss some great tips that will help you quickly and efficiently clone your Oracle database for Oracle versions Oracle 8.1.5 to Oracle 10g. Article Continues below...

Backup:

First of all you need to have a valid backup of your database. You should take the backup of your database in both Non-Archive Log Mode and Archivelog Mode.

Connection:

Now you will connect to SQL*PLUS as SYSDBA.

SQL> CONNECT / AS SYSDBA

You must make sure that no other user is logged into the system. When you run below command then you find a number of rows returned. These rows will include you as a SYS login and some internal Oracle logins. These internal Oracle accounts and your account will not affect the operation but you must ensure that no other user is logged in.

SQL> SELECT USERNAME FROM V$SESSION;

Enable Restricted Session:

Now you will need to enable restricted session so as to place your system in restricted mode.

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

Backup Controlfile To Trace:

Oracle BACKUP CONTROLFILE TO TRACE command writes SQL statements to the database's trace file instead of making a physical backup of the control file. This command will generate a SQL script that can be used to regenerate the database. Now you will have to connect as SYS with SYSDBA privileges and then run below SQL command.

SQL> CONNECT / AS SYSDBA
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Find User Dump Directory:

Now you will have to execute below SQL*PLUS so as to find your user dump directory.

SQL> SHOW PARAMETER USER_DUMP_DEST

Move to User Dump Directory:

Now you will need to exit the Operating System Layer and move to the USER_DUMP_DEST directory. Continued...

Page: 1 2

 More Oracle Articles, Database Articles and DBA Tips
   Database Security: Step by step guideline
   Beware of PL/SQL Performance Problems!!
   Database Tuning Guide for Third Party Applications
   Great Tips for Removing Jobs from Job Queue Automatically!!
   Great Tips for Oracle Cancel-Based Recovery!!