Replication problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Replication problem

  1. #1
    Join Date
    May 2000
    Location
    france
    Posts
    2

    Question

    Hello,

    I've got a 8.1 database on a server and i want to relicate it on another server.

    My database files are under D:\oracle\oradata\myDBname on a server
    and i want to replicate it on C:\oracle\oradata\myDBname on the other server.

    I did copy all files from D:\oracle\oradata\myDBname to C:\oracle\oradata\myDBname but when i try to open the database i've got error: it's not possible to identify or lock the datafile 1 D:\oracle\oradata\myDBname\system01.dbf

    I tried to create D:\oracle\oradata\myDBname on the second server and to put it this file but i still got the same error...

    What should i do to replicate this correctly.
    Thank you very much

    Olivier

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    The error it is showing is because u have not shutdown ur database and copied the datafiles to the other server.This error happens when u try to copy the datafiles from onse server to another without shutting down the database.
    The remedy to the problem is shut down ur primary database ,copy the datafiles to the another server.Copy the datafiles to the same destination as the original one.If ua re changing the path then startup the instance and mount the database and change the path and open the database.
    In case of any help please be free to ask to me at rohitsn@altavista.com


    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  3. #3
    Join Date
    Nov 2000
    Posts
    245

    I guess you are trying to clone a database not implement oracle replication feature.

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