How to mimimize downtime to move a 10Tb database to a new box
Hi everyone,
My thoughts are as following, please comments:
1) create db skeleton in new box;
2) backup source;
3) in new box, nomount with copy of spfile;
4) mount with control file;
5) restore until cancel;
6) ship new archive logs to new box;
7) recover db until cancel(but don't cancel until the source is finally shutdown);
8) apply all logs and open resetlogs;
9) switch the app to the new db.(no password/no sid changes...just dns).
Please share your experiences! or point me to useful documentations.
Thanks,
Ken
My thoughts are as following, please comments:
1) create db skeleton in new box;
2) backup source;
3) in new box, nomount with copy of spfile;
4) mount with control file;
5) restore until cancel;
6) ship new archive logs to new box;
7) recover db until cancel(but don't cancel until the source is finally shutdown);
8) apply all logs and open resetlogs;
9) switch the app to the new db.(no password/no sid changes...just dns).
Please share your experiences! or point me to useful documentations.
Thanks,
Ken
0