Re: Database Cloning

I seriously doubt, that this is the standard procedure to clone a database. This may work, when you use *exactly* the same versions of operating system and db-engine, but I wouldn't recommend it. Why on Earth are you not using the exp and imp utilities? It is quite obvious, that Oracle data files have different structure on different OS platfoms and there is no chance to get your db up on HP that easily.

HTH,
Juhan

wteague_at_my-deja.com wrote:
>
> 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.
 

-- 
+-----------------+
|NB! Please remove|
|   .NICHT-SPAM   |
|  when replying  |
|    to get my    |
|     *REAL*      |
| e-mail address! |
|                 |
|  Cheers, Juhan  |
+-----------------+