Database copy
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Database copy

Hybrid View

  1. #1
    Join Date
    Jul 2000
    Posts
    23
    Hi ,

    I need to copy all my schema objects,data everything to create an another database, In the same machine with new instance

    exact copy of my database in another name, How do i do it .

    Arun

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Take the init.ora of the existing db, make relevant changes to it. Create the db using this file. Then either:
    1. Take export from existing db, import into the new db.
    2. Backup the controlfile to trace. Replace the dbf, redo log files with the dbf, redo log files of the old db. Edit the trace backup of the controlfile and recreate the controlfile using this file, startup the db.

    [Edited by Halo on 11-03-2000 at 06:08 PM]

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Just clone it, that will be easier and faster.
    Take cold backup. Make changes in init.ora file. Take the control file to trace. And make changes to that text file. Copy all of them to the new location apart from all datafiles, logfiles. Recover it on the new place. It should work fine.

    Thanks
    Kishore Kumar

  4. #4
    Join Date
    Sep 2000
    Posts
    17
    In the control file after modifying use SET instead of Reuse for different DB name.

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