Transfer Oracle Database to another server: Difference between revisions
Jump to navigation
Jump to search
(Created page with " 1. Make sure your source database is in archive log mode. 2. Begin backup all tablespaces in the source DB. 3. copy all datafiles in backup mode to the destination server. (v...") |
No edit summary |
||
| Line 1: | Line 1: | ||
# Make sure your source database is in archive log mode. | |||
# Begin backup all tablespaces in the source DB. | |||
# copy all datafiles in backup mode to the destination server. (via rcp/ftp or whatever you like..) | |||
# End backup all tablespaces in the source DB. | |||
# "ALTER SYSTEM ARCHIVE LOG CURRENT" in the source DB. | |||
# Copy the archive logs generated to the destination server. | |||
# Startup the cloned database with normal recovery procedure. i.e. : startup mount -> recover database -> alter database open... | |||
i.e. | |||
startup mount -> recover database -> alter database open... | |||
Latest revision as of 03:00, 14 October 2014
- Make sure your source database is in archive log mode.
- Begin backup all tablespaces in the source DB.
- copy all datafiles in backup mode to the destination server. (via rcp/ftp or whatever you like..)
- End backup all tablespaces in the source DB.
- "ALTER SYSTEM ARCHIVE LOG CURRENT" in the source DB.
- Copy the archive logs generated to the destination server.
- Startup the cloned database with normal recovery procedure. i.e. : startup mount -> recover database -> alter database open...