Professional Web Applications Themes

How to duplicate whole database from one machine to another machine in Windows 2000? - Oracle Server

Would you please what files I have to copy? Thanks. "Ban Spam" <ban-spamoperamail.com> wrote in message news:Xns92DBB436C5D42SunnySD68.6.19.6... > "HK Chang" <REMOVETHIS_hkchangbigfoot.com> wrote in > news:ask5lc$kv7$1news.hgc.com.hk: > > > Dear All, > > > > Do you know how I can duplicate the whole database from one Windows 2000 > > machine to another Windows 2000 machine? > > > > Thanks. > > > > Regards, > > HK Chang > > > > > > I'd just use COPY when the database is shut down....

  1. #1

    Default Re: How to duplicate whole database from one machine to another machine in Windows 2000?

    Would you please what files I have to copy?

    Thanks.
    "Ban Spam" <ban-spamoperamail.com> wrote in message
    news:Xns92DBB436C5D42SunnySD68.6.19.6...
    > "HK Chang" <REMOVETHIS_hkchangbigfoot.com> wrote in
    > news:ask5lc$kv7$1news.hgc.com.hk:
    >
    > > Dear All,
    > >
    > > Do you know how I can duplicate the whole database from one Windows 2000
    > > machine to another Windows 2000 machine?
    > >
    > > Thanks.
    > >
    > > Regards,
    > > HK Chang
    > >
    > >
    >
    > I'd just use COPY when the database is shut down.

    HK Chang Guest

  2. #2

    Default Re: How to duplicate whole database from one machine to another machine in Windows 2000?

    If you are using a version of Oracle that is less than 8i, you could
    follow the following steps..

    1. Shut down the database services,
    2. Copy the "dbs" and "database" folders within oracle installation
    directory,
    3. Re-start the services.

    Remember the machine to be copied to should also have its services
    shut down

    Ideally, you have to copy only selected files from "dbs" and
    "database", but I am not an expert at that and can just say that
    copying all the files in the 2 folders - "dbs" and "database" used to
    work for me.


    If the database is very big ( approx > 200MB) you will have to export
    it though.

    Laxman


    "HK Chang" <REMOVETHIS_hkchangbigfoot.com> wrote in message news:<asp0b3$31du$1news.hgc.com.hk>...
    > Would you please what files I have to copy?
    >
    > Thanks.
    > "Ban Spam" <ban-spamoperamail.com> wrote in message
    > news:Xns92DBB436C5D42SunnySD68.6.19.6...
    > > "HK Chang" <REMOVETHIS_hkchangbigfoot.com> wrote in
    > > news:ask5lc$kv7$1news.hgc.com.hk:
    > >
    > > > Dear All,
    > > >
    > > > Do you know how I can duplicate the whole database from one Windows 2000
    > > > machine to another Windows 2000 machine?
    > > >
    > > > Thanks.
    > > >
    > > > Regards,
    > > > HK Chang
    > > >
    > > >
    > >
    > > I'd just use COPY when the database is shut down.
    Laxman Uchlani Guest

  3. #3

    Default Re: How to duplicate whole database from one machine to another machine in Windows 2000?

    > I should have mentioned it explicitly, but my technique was meant if
    > we want to hand over the task to a person not exposed to databases at
    > all, and we do not want to give him/her the SYS password also.
    > A few extra minutes spent copying for that person is sometimes better
    > than teaching him the intricacies.
    Hi Laxman,

    Handing over database migration tasks to someone who has not been
    exposed to databases at all is asking for a *BIG* trouble. Practicing
    Oracle on a home machine is much different then working with a
    production instance in the real world.

    If it is just a practice on a home machine...then no harm done, *BUT*
    if it is a real world scenario...then let the DBA handle these kind of
    tasks.

    Regards
    /Rauf Sarwar
    Rauf Sarwar Guest

Similar Threads

  1. MSDE 2000 SP3 on a Windows 2003 Server machine.
    By Yiannos in forum Windows Server
    Replies: 3
    Last Post: June 30th, 01:56 PM
  2. Replies: 2
    Last Post: June 17th, 12:08 AM
  3. Change Machine Name For Windows 2000 Server Domain
    By Rick in forum Windows Server
    Replies: 3
    Last Post: June 14th, 04:56 PM
  4. Getting files from a Win 2000 machine to a Windows XP machine
    By John Mycroft in forum Windows Networking
    Replies: 0
    Last Post: July 11th, 11:52 AM
  5. can't get 2000 machine to read xp pro machine
    By andy in forum Windows Networking
    Replies: 0
    Last Post: July 2nd, 11:31 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139