Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!87.79.20.101.MISMATCH!newsreader4.netcologne.de!news.netcologne.de!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: Copying Oracle 10.2.0.4 Database to 11.2 Date: Mon, 8 Aug 2011 23:58:18 +0000 (UTC) Organization: solani.org Lines: 29 Message-ID: References: <2e5d62d9-0155-4ab2-9c55-dff6c8ecc0f2@k3g2000vbz.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1312847898 7549 eJwNx8kBwCAIBMCWWF0OyxEC/Zdg5je6DVZOU6OOTrPctvFf4haxBNQTkRHfYHhPdRZchA2sBwiXEGg= (8 Aug 2011 23:58:18 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Mon, 8 Aug 2011 23:58:18 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwNwoERADEEBMCW3HOMckTov4T87FId3mFON+4vGiLDKVTqoSxtI/TumHfWyboJs0+7qMADHGEQ9Q== Cancel-Lock: sha1:M9sfUkrF2ww/gl84rdYiRb8Uc3U= X-NNTP-Posting-Host: eJwNwokRwDAIA7CVSsCGjsMT9h+hPQlKYbsRNOxPmJ03aFtwJDX6xk2Uw0q1U3xF75uVSHtQoyM7cXojBkEecfHRp46e9wPsVxnx Xref: news.cambrium.nl On Mon, 08 Aug 2011 07:13:28 -0700, if_investor@yahoo.com wrote: > > On 11.2, will the "Create controlfile" command work if the database is > 10g? > > > Thanks, > QZ Oh my god! May He have mercy on your soul and help you not to lose your job. There are so many misconceptions above that it would take days to rectify them. I just did a very complex upgrade of RAC 9.2.0.8 to RAC 11.2.0.2, with moving from RH AS 2.1 to RH 4.8 at the same time and I know what I am talking about. First, you don't need "create controlfile" to rename instance. You just need to rename init file and the environment variable. Second, if you are copying from backup, then you shouldn't have the target database running. Third, SAP will be down during upgrade. SAP tools should not be used to upgrade database, unless of course, the "backup" you're talking about is a full export. Database upgrades are usually done by using dbua not SAP tools. In the case of full export, you don't need to re-create the control file or change the instance name. My advice is to do a dry run or two. This sounds like a DBA 2.0 trying to do a serious job. May the force be with you, my young padawan. -- http://mgogala.byethost5.com