Date: Fri, 10 Oct 2008 14:52:33 -0500
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)
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?
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205