Re: Migrate databases to new servers and storage

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Wed, 15 Oct 2014 23:10:05 -0500
Message-ID: <CAEueRAXgx+9nMRggHfg2StAMv42j=WRrbAfFBAO2QTDx86FgLw_at_mail.gmail.com>

That's a great point Hemant. Solaris 11 is so dramatically different from 10, you likely will not even be able to install the binaries (if you can even find them).

Seth Miller

On Wed, Oct 15, 2014 at 10:01 PM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com
> wrote:

>
>
> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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
> .
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 16 2014 - 06:10:05 CEST