Oracle migration: What is the best approach to migrate a 24/7 8I database to a 9I database in a new box and minimize the downtime ?
I am thinking on using a backup (cold/hot or RMAN) to the new box that is preloaded with 9I( + 9.0.5 patch) with a new instance same SID, same dbname, run the migration script and .. . how can I synchronize or serialize with the old 8I database that is still running after the migration 9I database? Can I apply the 8I archive log files to the 9I database, and how ?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 24, 2005 2:01 PM
UPDATED:
March 30, 2005 12:49 PM
Answer Wiki:
Sounds tricky, not sure you can do anything clever with the Oracle redo log files you'd have to check with support, but I doubt it.
You could always got for a logical replication type move, using snapshots, but it depends on your data volumes. All systems have quiter periods and you could use that time to do the cut over.
If your DB is small enough and you do have some downtime then you may be able to migrate.
There will be a time when you'll need to do a cut over where you app servers/clients all point to the new instance.
So how big is the DB, and how 24/7?
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
