Sanity Check

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_at_ingrambarge.com  

--
http://www.freelists.org/webpage/oracle-l