cold backup restore to different database

[beechill4]

Hi,

i have 2 10g databases on different machines.

i am taking a cold backup of dbA and copying all files to the exact same location on server b where the other database is based.

how do i get the second database up and running with the datafiles etc from b?

Thanks

 

[SantaMufasa]

i am taking a cold backup of dbA and copying all files to the exact same location on server b...

As a quality check in your case, could you please confirm what types/classes of files you have copied from Server A to Server B? (e.g. Database data files, on-line redo log files, and hopefully more, but I want to hear from you what those additional files are.)

Also, have you tried starting up Server B's database yet with Server A's db files? If so, what were your results? If there were errors, could you please post them here.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[beechill4]

dave,

i will be copying the parameter file, control file script (after a backup control file to trace) ,the redo log files, and the datafiles.

i have found a good clear and concise guide to all of this:

http://www.samoratech.com/topicofinterest/swclonedb.htm

i think this is what i need

 

[SantaMufasa]

Yes, Beechill, the list of files that you offered is correct.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.