From oracle-l-bounce@freelists.org Tue Apr 12 16:52:23 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3CLqN83016222 for ; Tue, 12 Apr 2005 16:52:23 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3CLqNem016218 for ; Tue, 12 Apr 2005 16:52:23 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EA6259494A; Tue, 12 Apr 2005 15:50:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16020-10; Tue, 12 Apr 2005 15:50:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6330C9475C; Tue, 12 Apr 2005 15:50:12 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: coping oracle to another server Date: Tue, 12 Apr 2005 16:28:33 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: coping oracle to another server Thread-Index: AcU/nYK4P+vet+ZTS/ynBBqevy2VjwAAElGw From: To: , X-OriginalArrivalTime: 12 Apr 2005 20:28:33.0976 (UTC) FILETIME=[32CF5B80:01C53F9E] X-CanItPRO-Stream: default X-Spam-Score: undef - spam-scanning disabled X-Scanned-By: CanIt (www . roaringpenguin . com) on 167.78.2.22 X-archive-position: 18399 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Paula_Stankus@doh.state.fl.us Precedence: normal Reply-To: Paula_Stankus@doh.state.fl.us X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.3 required=5.0 tests=AWL,NO_REAL_NAME autolearn=no version=2.60 X-Spam-Level: 1-Shutdown entire database 2-Copy all files including the control files - don't need to create from a script 3-Startup mount 4-alter database open resetlogs=20 The above steps should work - I have done same in the past. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Paul Baumgartel Sent: Tuesday, April 12, 2005 4:24 PM To: Oracle-L@Freelists. Org (E-mail) Subject: Re: coping oracle to another server IIRC, you will have to startup mount the new database and recover it before you can open it. The backup and recovery experts on the list will correct me if I=3DE8m wrong. On Apr 12, 2005 4:07 PM, Roger Xu wrote: > Oracle 9.2.0.4.0 on Solaris 8 (SUNW,Sun-Fire-V890) =3D20 =3D20 =20 >-----Original Message----- > From: oracle-l-bounce@freelists.org > [ mailto:oracle-l-bounce@freelists.org]On Behalf Of Roger Xu > Sent: Tuesday, April 12, 2005 2:59 PM > To: Oracle-L@Freelists. Org (E-mail) > Subject: coping oracle to another server =3D20 Hello List, =3D20 = This is >what I did: > * alter database backup controlfile to trace > * shutdown oracle on ServerA and tar everything under /oracle to a=20 >tape > * on ServerB, untar the tape to /oracle > * startup nomount and recreate controlfile =3D20 Here is the error: >=3D20 > SQL> @/scripts/control.sql >=3D20 > Control file created. >=3D20 > SQL> alter database open resetlogs; > alter database open resetlogs > * > ERROR at line 1: > ORA-01152: file 1 was not restored from a sufficiently old backup > ORA-01110: data file 1: '/oracle/DV1/sapdata1/system_1/system.data1' >=3D20 > Did I do anything wrong? What could be the fix? >=3D20 > Thanks, >=3D20 > Roger > This e-mail is intended solely for the person or entity to which it is >ad=3D dressed and may contain confidential and/or privileged information. Any rev=3D iew, dissemination, copying, printing or other use of this e-mail by person=3D s or entities other than the addressee is prohibited. If = you have received =3D this e-mail in error, please contact the sender immediately and delete the =3D material. > ____________________________________________________________________ > This email has been scanned for all viruses by the MessageLabs Email=20 > Secu=3D rity System. Any questions please call 972-721-8257 or email your request t=3D o tech_support@dp7uptx.com. > -- > http://www.freelists.org/webpage/oracle-l >=3D20 > For technical support please email tech_support@dp7uptx.com or you can >call (972)721-8257. > This email has been scanned for all viruses by the MessageLabs Email=20 >Secu=3D rity System. >=3D20 > This e-mail is intended solely for the person or entity to which it is >ad=3D dressed and may contain confidential and/or privileged information. Any rev=3D iew, dissemination, copying, printing or other use of this e-mail by person=3D s or entities other than the addressee is prohibited. If = you have received =3D this e-mail in error, please contact the sender immediately and delete the =3D material. > ____________________________________________________________________ > This email has been scanned for all viruses by the MessageLabs Email=20 > Secu=3D rity System. Any questions please call 972-721-8257 or email your request t=3D o tech_support@dp7uptx.com. > -- > http://www.freelists.org/webpage/oracle-l >=3D20 --=3D20 Paul Baumgartel paul.baumgartel@gmail.com -- http://www.freelists.org/webpage/oracle-l BEGIN-ANTISPAM-VOTING-LINKS ------------------------------------------------------ Teach CanIt if this mail (ID 29431359) is spam: Spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D29431359&m=3Ddd28= 2bdc6 e83 Not spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D29431359&m=3Ddd28= 2bdc6 e83 Forget vote: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D29431359&m=3Ddd28= 2bdc6 e83 ------------------------------------------------------ END-ANTISPAM-VOTING-LINKS -- http://www.freelists.org/webpage/oracle-l