Back up Question

[sureshgane]

we are having 2 databasees running in WindowsN/T.They are going to replace the machine with a new one.So I would like to know what all files needed to be backed up so that later I can use for the same database creation in the new machine.Presently I need to backup files from machine A to Machine B & later from Machine B to new machine.So do send the step by step approach to back up whatall files from Machine A to Machineb.I am running oracle 8.1.5 & it is a test database.As of such no archiving & it's not a 24X7.Thanks in advance for all the suggestions
Thanks
G.Suresh

[tamilselvan]

If you use same directory on both machines and same release of Oracle, take backup of control files, redo log files, data files, init.ora , config,ora and then copy them into new machine.

If the Oracle release is different, do export and import or Migration utility.

[jgmagnus]

Basically if you do a cold backup and then insert all those files into the proper directories in the new server, you should be all set.

Otherwise you can also jsut do a full Export like Tamil said.

- Magnus

[sureshgane]

Thanks!!!!!!!!!!!