To: Multiple recipients of list ORACLE-L
Subject:Re: Moving a database to a different machine
Steve,
Do you recall doing this about 5 years ago?
I recall doing this same procedure there, but without
benefit of standby database.
Total downtime was less than 2 hours, and we did
it during a slow
I think this will work fine. You could play with doing it with a standby
database, the only advantage to that is that you could start the backup and
move of files earlier in the process and just keep recovering the archived
logs as you ship them across.
This has the advantage of giving you
Title: RE: Moving a database to a different machine
Hi Steve,
I used this same strategy with a migration last month. It minimized our database related downtime to 30 minutes (and then they unplugged the symmetrix and the app server was down for 12 hours. Oh well)
This plan will work
Koivu, Lisa said
A word of warning, and you probably already know this: you can't have both
databases open at the same time or you will end up with incompatible archive
logs and control files. Good luck !
hehe I did know, but upon reading your warning it still frightened me for a
moment.
Steve,
Do you recall doing this about 5 years ago?
I recall doing this same procedure there, but without
benefit of standby database.
Total downtime was less than 2 hours, and we did
it during a slow period. ( probably Saturday night :(
Jared
On Thursday 17 May 2001 13:48, Steve McClure