||Oracle Tips by Burleson
Chapter 5 - Oracle Database
OCP Instructors Guide for
Oracle DBA Certification
Copying Databases Between Servers
Don't use the EXPORT/IMPORT utility to copy
databases between servers running the same operating system. Execute
the following steps to speed the transfer:
Execute the ALTER DATABASE BACKUP CONTROLFILE
TO TRACE; statement on the source server.
Bring the database down and copy the trace
file, parameter file, all datafiles, control files and redo logs to
the new server.
Make the following changes to the trace file
created in step 1:
If you are changing the database name, change
the first line of the create statement to reflect the new name and
change the REUSE keyword to SET.
Change NORESETLOGS to RESETLOGS.
Change directory names if they have changed on
the new database server.
Delete all comments and lines that have a # in
front of them (#s aren't comments in all Oracle tools).
Connect as INTERNAL and run the SQL statement
contained in the trace file. It will start up the database in
NOMOUNT stage and recreate the control files. The SQL statementís
final step will be to MOUNT and then OPEN the database.
What happens if you canít take the database
down? Youíll have to execute a hot backup, which means your
database will have to be in ARCHIVELOG mode. Here are the steps you
will have to perform to copy an online database to a new server.
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
by Christopher T. Foot
For more details and scripts, see my new book "
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot.