Re: Sanity Check

  • From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
  • To: Chris.Taylor@xxxxxxxxxxxxxxx
  • Date: Fri, 10 Oct 2008 16:04:59 -0400

This doesn't really answer your question, but I would have built a standby
on the new hardware and then done a switchover at the time of the actual
migration. Guaranteed no dataloss. Then pull down the old primary/new
standby after you're done and sure all is well.


On Fri, Oct 10, 2008 at 3:52 PM, Taylor, Chris David <
Chris.Taylor@xxxxxxxxxxxxxxx> wrote:

>  Guys & Gals,
> We have a database migration to new hardware tomorrow and this is something
> I was considering doing to save time tomorrow.  I wanted to get a sanity
> check to see if I'm missing anything or have failed to consider anything.
> 1.) Restore prod database to the new machine (same name, same paths)
> tonight
> 2.) Shutdown prod database tomorrow and switch logfiles as part of the
> shutdown (shutdown trigger) to generate final archivelogs on old machine
> 3.) Copy archivelogs from old machine after shutdown to new machine
> 4.) Recover <new> prod database on new machine
> 5.) Open <new> prod database on new machine with resetlogs
> 6.) Take a backup of <new> prod database
> Do I run any risk of losing transactions in the existing prod database?
> Anything I've failed to consider?
> Thanks!
> *Chris Taylor*
> *Sr. Oracle DBA*
> Ingram Barge Company
> Nashville, TN 37205
> Office: 615-517-3355
> Cell: 615-354-4799
> Email: chris.taylor@xxxxxxxxxxxxxxx

Other related posts: