Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004

    Unanswered: cloning database not going according to plan.

    {edited.. solved that problem.. onto the next:}

    I'm trying to clone a database from one instance on one box, to another instance on another box. Stage1 to live1. live1 is a brand new install, with no existing data.

    I've copied across the datafiles, have copied over and modified the init.ora, and have modified the create_controlfile.sql script I output from the source to reflect the new datafile locations and SID.

    I do the following, and get the shown errors.

    bash-2.05$sqlplus /nolog
    SQL*Plus: Release - Production on Mon Mar 6 10:45:24 2006
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    SQL> connect system/manager as sysdba
    Connected to an idle instance.
    SQL> @/apps/oracle/admin/live1/pfile/stage1_control_script.sql
    ORACLE instance started.
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01200: actual file size of 518528 is smaller than correct size of 4188544
    ORA-01110: data file 10: '/disk03/oradata/live1/data/msimage01live1.dbf'
    ALTER TABLESPACE TEMP ADD TEMPFILE '/disk01/oradata/live1/data/temp01live1.dbf'
    ERROR at line 1:
    ORA-01109: database not open
    does this read the datafile size from the header of the datafile itself, and if so, does that mean the file is truncated from the source?

    not done a clone before, but there data is too big for an exp/imp (took several days last time)

    thanks in advance.

    Last edited by arpoodle; 03-06-06 at 07:59.

  2. #2
    Join Date
    Mar 2002
    Reading, UK
    This article is very good on cloning and helped us to do it


  3. #3
    Join Date
    Jun 2004
    Provided Answers: 1
    These notes might help:

    When I had to clone databases, I found that by googling for 'rename a database' I got some good information (as renaming involves cloning an existing database).

    There are also some good notes on Metalink about renaming a database, so you might want to take a look there, as well.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts