Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RMAN Duplication for Migration and Archived Logs
OK here it is. Currently we're on Oracle 10.2.0.2 on 32-bit RHEL 3.
We're going to be migrating to the same version (10.2.0.2) on a 64-bit
RHEL 4 box.
I've done this migration plenty of times to create development instances. However, in the case of the actual production migration, we have the question of downtime. My production-to-development duplications are currently taking 10 hours, in there I use the UNTIL TIME parameter to tell it to do the PITR. I've been given an 12-hour overnight downtime window (10 PM Saturday to 10 AM Sunday).
I'm wondering if I can minimize the downtime by starting the duplication earlier while the production database is still running.
Here is our current backup scenario:
* Full backup Saturday evenings to disk
This is the crazy scheme I've been concocting in my head:
Obviously the big "IFs" are:
1. Will RMAN let me specify UNTIL TIME into the future? e.g. saying
UNTIL TIME of 10 PM when it is only 3 PM.
2. Will RMAN need those backup pieces on local disk before it begins
duplication? I'm assuming it doesn't since I've found out that pieces
are missing 8 hours into a duplication.
If anyone can tell me if this is a crackpot scheme that just might work, or simply not possible with rman, I'd appreciate it. Worst case scenario is that I perform the restore/recovery completely within the downtime window.
-- Don Seiler oracle: http://ora.seiler.us ultimate: http://www.mufc.us -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 01 2007 - 14:45:07 CDT
![]() |
![]() |