Search BC Sites

Free Oracle Tips   HTML Text

Free Oracle App Server Tips   HTML Text

Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Copying Databases Between Servers

• Execute the hot backup, making sure all of the files are backed up. Note the time after the last tablespace is backed up.
   

• Execute ALTER SYSTEM SWITCH LOGFILE; to archive the last redo log that was active during the hot backup.
   

• Execute the ALTER DATABASE BACKUP CONTROLFILE TO TRACE; statement on the source server.
   

• Execute the ALTER DATABASE BACKUP CONTROLFILE TO filename; statement on the source server.
   

• Copy the datafile backups, both controlfile backups (backup to trace, backup to filename) and the archived redo logs that were generated during the hot backups.  Make sure you match the directory structures that are on the source platform.
   

• Execute the RECOVER DATABASE UNTIL TIME XXXXX USING BACKUP CONTROLFILE; to recover the database on the new platform.  Pick a time just after the hot backup was complete. If the file or directory names will be different on the target server, bring the database to MOUNT stage and issue the ALTER DATABASE RENAME FILE oldfilename TO newfilename command to point the control file to the new locations. 
   

• If you need to change the database name, execute the following changes to the trace file created in step 1:
   

For more details and scripts, see my new book " Oracle 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.