RE: Moving a database to a different machine

2001-05-24 Thread Steve McClure
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

Re: Moving a database to a different machine

2001-05-17 Thread Rachel Carmichael
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

RE: Moving a database to a different machine

2001-05-17 Thread Koivu, Lisa
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

RE: Moving a database to a different machine

2001-05-17 Thread Steve McClure
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.

Re: Moving a database to a different machine

2001-05-17 Thread Jared Still
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