Re: Database upgrade for big database
From: Kamus <kamusis_at_gmail.com>
Date: Mon, 27 Aug 2012 00:31:53 +0800
Message-ID: <7E0FB14283D24EBE8AE5C6FABDA68D73_at_gmail.com>
We did a lot of database migration and upgrade works in the past few years, from 9i to 10g to 11g. Yes, the method you mentioned is the best process if source and target has the same platform, incase you can't use Data Guard due to different platform, you can use Goldengate (or MV refresh if has budget concern) to sync data before downtime. In this process, the initial data load is the most difficult part, you have to consider how to split the big tables into little pieces (if unfortunately in your database has some big tables without partition) to make initial works quickly to avoid ORA-1555 error.
Date: Mon, 27 Aug 2012 00:31:53 +0800
Message-ID: <7E0FB14283D24EBE8AE5C6FABDA68D73_at_gmail.com>
We did a lot of database migration and upgrade works in the past few years, from 9i to 10g to 11g. Yes, the method you mentioned is the best process if source and target has the same platform, incase you can't use Data Guard due to different platform, you can use Goldengate (or MV refresh if has budget concern) to sync data before downtime. In this process, the initial data load is the most difficult part, you have to consider how to split the big tables into little pieces (if unfortunately in your database has some big tables without partition) to make initial works quickly to avoid ORA-1555 error.
-- Kamus <kamusis_at_gmail.com> Visit my blog for more : http://www.dbform.com Join ACOUG: http://www.acoug.org On Saturday, August 25, 2012 at 2:33 AM, Sanjay Mishra wrote:Received on Sun Aug 26 2012 - 11:31:53 CDT
> Hi
> Can someone share his experience in upgrading some big databases like 1Tb or so from 10g to 11g and also moving them to new server.
> I had few database running in 10g and has to be moved to new server with 11g. So looking for some suggestion and any URl/Metalink Doc for reference.
>
> One of them can be
> 1. Create standby server for 10g on new server
> 2. Install Oracle 11g with all required Paches
> 3. stop the primary and activate the Standby server
> 4. Upgrade the Standby server with 11g Software already installed
>
> This process will save in installing Oracle 11g and performing any datapump export/import and save big downtime to few hours only while upgrading the environment.
>
> Any more suggestions or reference will be helpful
>
> TIA
> Sanjay
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-l