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@(protected)> wrote: > Oracle 9.2.0.4.0 on Solaris 8 (SUNW,Sun-Fire-V890) >=20 >=20 > -- --Original Message-- -- > From: oracle-l-bounce@(protected) > [ mailto:oracle-l-bounce@(protected)]On Behalf Of Roger Xu > Sent: Tuesday, April 12, 2005 2:59 PM > To: Oracle-L@(protected) 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 (See ORA-01152.ora-code.com): file 1 was not restored from a sufficiently old backup > ORA-01110 (See ORA-01110.ora-code.com): 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@(protected) > -- > http://www.freelists.org/webpage/oracle-l >=20 > For technical support please email tech_support@(protected) 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@(protected) > -- > http://www.freelists.org/webpage/oracle-l >=20
--=20 Paul Baumgartel paul.baumgartel@(protected) -- http://www.freelists.org/webpage/oracle-l
