Database Backup and Recovery (MOSC)

MOSC Banner

How to mimimize downtime to move a 10Tb database to a new box

edited Jan 24, 2014 8:42AM in Database Backup and Recovery (MOSC) 7 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center