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_at_dp7uptx.com> wrote:
> Oracle 9.2.0.4.0 on Solaris 8 (SUNW,Sun-Fire-V890)
>=20
>=20
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [ mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu
> Sent: Tuesday, April 12, 2005 2:59 PM
> To: Oracle-L_at_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_at_dp7uptx.com.
> --
> http://www.freelists.org/webpage/oracle-l
>=20
> For technical support please email tech_support_at_dp7uptx.com 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_at_dp7uptx.com.
> --
> http://www.freelists.org/webpage/oracle-l
>=20
--=20
Paul Baumgartel
paul.baumgartel_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 12 2005 - 16:27:30 CDT
