Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Move large database to other server using RMAN in less downtime

556923Jan 18 2012 — edited Jan 30 2013
Hi,

We have large database around 20TB. We want to migrate (move) the database from one server to other server. We do not want to use standby option.
1) How can we move database using RMAN in less downtime
2) Other than RMAN is there any option is available to move the database to new server

For option 1 (restore using RMAN),

Whether below options are valid?
If this option is valid, how to implement this?


1) How can we move database using RMAN in less downtime
a) Take the full backup from source (source db is up)
b) Restore the full backup in target (source db is up)
c) Take the incremental backup from source (source db is up)
d) Restore incremental backup in target (source db is up)
e) Do steps c and d, before taking downtime (source db is up)
f) Shutdown and mount the source db, and take the incremental backup (source db is down)
g) Restore last incremental backup and start the target database (target is up and application is accessing this new db


database version: 10.2.0.4
OS: SUN solaris 10

Edited by: Rajak on Jan 18, 2012 4:56 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2013
Added on Jan 18 2012
15 comments
4,007 views