RE: coping oracle to another server

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Tue, 12 Apr 2005 15:07:44 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F7059C93E2@irv2kexch01>

Oracle 9.2.0.4.0 on Solaris 8 (SUNW,Sun-Fire-V890)

-----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

Hello List,

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

Here is the error:

SQL> @/scripts/control.sql

Control file created.

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'

Did I do anything wrong? What could be the fix?

Thanks,

Roger
This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons 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 Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.

--
http://www.freelists.org/webpage/oracle-l

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 Security System.



This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons 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 Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 12 2005 - 16:11:59 CDT