DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Cloning Database

  1. #1
    Join Date
    Aug 2001
    Posts
    87

    Cloning Database

    Hi,

    I have prod database in the Target sever
    I need to have copy of it in another server
    Same operating system win 2003 , and same database 9i

    I restore the backup of the production in the target server and
    into the test one then i did
    create for the control file ( test database base available before)
    but after issue the script of the creation of the database (controlfile)
    it seems that it is hang and show me only
    number
    429
    I don't know what to do please support.

    Here your the header of my script
    -----
    CREATE CONTROLFILE REUSE SET DATABASE "dev" RESETLOGS NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 450
    MAXINSTANCES 16
    MAXLOGHISTORY 1815
    LOGFILE
    GROUP 1 ('D:\APPS11I\PRODDATA\LOG01A.DBF', 'D:\APPS11I\PRODDATA\LOG01B.DBF') SIZE 10485760,
    GROUP 2 ('D:\APPS11I\PRODDATA\LOG02A.DBF', 'D:\APPS11I\PRODDATA\LOG02B.DBF') SIZE 10485760
    DATAFILE

    -------------

    best regards

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    is there a / at the end?

Posting Permissions

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


Click Here to Expand Forum to Full Width