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=E8m wrong. On Apr 12, 2005 4:07 PM, Roger Xu <roger_xu@xxxxxxxxxxx> wrote: > Oracle 9.2.0.4.0 on Solaris 8 (SUNW,Sun-Fire-V890) >=20 >=20 > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [ mailto:oracle-l-bounce@xxxxxxxxxxxxx]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 >=20 > Hello List, >=20 > This is what I did: > * alter database backup controlfile to trace > * shutdown oracle on ServerA and tar everything under /oracle to a tape > * on ServerB, untar the tape to /oracle > * startup nomount and recreate controlfile >=20 > Here is the error: >=20 > SQL> @/scripts/control.sql >=20 > Control file created. >=20 > 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' >=20 > Did I do anything wrong? What could be the fix? >=20 > Thanks, >=20 > Roger > This e-mail is intended solely for the person or entity to which it is ad= dressed and may contain confidential and/or privileged information. Any rev= iew, dissemination, copying, printing or other use of this e-mail by person= s or entities other than the addressee is prohibited. If you have received = this e-mail in error, please contact the sender immediately and delete the = material. > ____________________________________________________________________ > This email has been scanned for all viruses by the MessageLabs Email Secu= rity System. Any questions please call 972-721-8257 or email your request t= o tech_support@xxxxxxxxxxxx > -- > //www.freelists.org/webpage/oracle-l >=20 > For technical support please email tech_support@xxxxxxxxxxx or you can > call (972)721-8257. > This email has been scanned for all viruses by the MessageLabs Email Secu= rity System. >=20 > This e-mail is intended solely for the person or entity to which it is ad= dressed and may contain confidential and/or privileged information. Any rev= iew, dissemination, copying, printing or other use of this e-mail by person= s or entities other than the addressee is prohibited. If you have received = this e-mail in error, please contact the sender immediately and delete the = material. > ____________________________________________________________________ > This email has been scanned for all viruses by the MessageLabs Email Secu= rity System. Any questions please call 972-721-8257 or email your request t= o tech_support@xxxxxxxxxxxx > -- > //www.freelists.org/webpage/oracle-l >=20 --=20 Paul Baumgartel paul.baumgartel@xxxxxxxxx -- //www.freelists.org/webpage/oracle-l