Database Backup and Recovery (MOSC)

MOSC Banner

Opinions on best method to move a database instance to a new server..

edited Apr 22, 2010 7:25AM in Database Backup and Recovery (MOSC) 11 commentsAnswered
Hi all.  I am looking for opinions on the best method to move a database instance to a new server with a few requirements.  Currently we are using 9.2.0.7 as it is required by the application we are running.  Once the db is moved, the old instance will be shut down.  
For example sake, our current db instance is named prod and is about 350GB.  

On the new server, I would like to keep the same instance name of prod.  However, I would like to move the data to an already created instance on the new server so I can create a somewhat different configuration for tablespace storage, memory and archiving.  I would like to do this to consolidate some data files and reduce data file extents. (The db was created prior to my time and used very small storage parameters, so many of the datafiles are either in extents, or were not created with autoextend and have filled up).  

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