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

    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.

    Code:
    bash-2.05$sqlplus /nolog
    
    SQL*Plus: Release 9.2.0.5.0 - 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.
    
    CREATE CONTROLFILE SET DATABASE "live1" RESETLOGS NOARCHIVELOG
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01200: actual file size of 518528 is smaller than correct size of 4188544
    blocks
    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
    
    
    SQL>
    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.

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

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

    http://www.dizwell.com/oracle/articl..._database.html

    Alan

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

    http://www.idevelopment.info/data/Or.../BandR_2.shtml

    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
  •