After All the preparation, I was able to migrate the database this past weekend.
It was mostly successful except for two issues. Note I my target database is 9i on Linux. Here are my outstanding issues:
1) In the target database, I have a missing datafile. Note this database is in partial...
I just got word that we dont even have enough space for stadby database.
Standby database will require approximate size of the source database. Also the source is windows OS while the target is a SOLARIS.
This gives me the idea of using the followin steps.
1)Do a full database export on day1...
Perhaps, there is a little window (during the off hours)that we can use to shutdown the source databsae and refresh target database with all the new changes and switch users using the new connection strings to new database.
I am might be inlcined to use the standby database.
Tayo
Hello All,
I am planning to migrate a database from one location to the other.
I have prepped my taget databse, all I need to do now is to export/imp the dump files.
However, this source database is being upadted continuously and there is little chance of shutting down the source, migrate and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.