Sanity Check

From: Taylor, Chris David <>
Date: Fri, 10 Oct 2008 14:52:33 -0500
Message-ID: <>

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?  


Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799

Received on Fri Oct 10 2008 - 14:52:33 CDT

Original text of this message