Opinions on best method to move a database instance to a new server..
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).
0