coping oracle to another server 2005-04-12 - By Paul Baumgartel
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
|
|
