RE: Migrate databases to new servers and storage
- From: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
- To: <sbecker6925@xxxxxxxxx>
- Date: Thu, 16 Oct 2014 11:01:00 +0800
Besides the obvious fact that you can't apply archivelogs and rman to a
database created through export-import :
1. 9.2 isn't certified on Solaris 11
2. 10.2. isn't certified on Solaris 11
You HAVE to upgrade your 9.2 and 10.2 (or 10.1) versions. You could use
RMAN Backups from 9.2 and 10.2 and RMAN Restore using 11.2 on the
Solaris 11 server and then upgrade the databases. See the answer to the
first question in Note#369644.1
You might consider rebuilding the Standbys if they are small ?!
Hemant K Chitale
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sandra Becker
Sent: Thursday, October 16, 2014 6:09 AM
To: oracle-l
Subject: Migrate databases to new servers and storage
Current Environment: Solaris 10, EE 9.2 through 11.2
New Environment: Solaris 11, no change to the Oracle versions
Databases range in size from 8G to 3T.
Over the next 5 months we will be moving our production databases to new
servers and storage. The consultants working with use (no DBAs) have
proposed the following method for moving the databases:
1. create new databases on the new servers
2. create an export of the current database
3. import into the new database
4. copy archivelogs to the new server
5. use RMAN to recover the new database
6. Consultants didn't address this - what do we do with standby
databases? Not every database has a standby.
This is really high level, but is this the best way to migrate the
databases? For the smaller databases that do not have a lot of DML or a
standby, I don't see this as problematic. Am I mistaken? What have
others done? Our downtime window for any one database is 4 hours.
The other oracle DBA and I have considered two other possible options:
1. import through a dblink
2. create a standby on the new server and switch it to primary during
the downtime window
Are these really valid options for us to consider?
Appreciate your suggestions and thoughts.
--
Sandy
GHX
This email and any attachments are confidential and may also be privileged. If
you are not the intended recipient, please delete all copies and notify the
sender immediately. You may wish to refer to the incorporation details of
Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at
https://www.sc.com/en/incorporation-details.html.
Other related posts:
