Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Database Cloning

Database Cloning

From: <wteague_at_my-deja.com>
Date: Fri, 06 Oct 2000 15:14:27 GMT
Message-ID: <8rkq8a$c6p$1@nnrp1.deja.com>

I am trying to port a database existing on a Sun server to a HP server.

The steps I followed are :

  1. Do the Alter database backup control file to trace from the 1st database.
  2. Shutdown the 1st Database
  3. Copy all the database files and log files to the new directory structures on HP server using FTP.
  4. Modify the init.ora of the 2nd instance to specify the db_name etc.
  5. Change the trace file generated by control file to trace utility to specify the new db_name (same as the init.ora of the 2nd database) and new directory structures.
  6. Startup Nomount the 2nd instance.
  7. Execute the control file trace script
  8. After I enter command 'alter database open resetlogs' I consistently get the error: ORA-01578: Oracle data block corrupted (file # , block # )

Any suggestions?

Thanks

Wade

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 06 2000 - 10:14:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US