coping oracle to another server

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Tue, 12 Apr 2005 14:58:38 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F7051837A7@irv2kexch01>

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

Received on Tue Apr 12 2005 - 16:02:56 CDT