Database urgent!!!!!!!!!!!!

[sureshgane]

How to create the same database like which is running in Machine A to Machine B.I want all the datafiles,schemas.Ucan say how to do with SVRMGrL AS WELL AS OTHER METHODS TOO
Thnaks
G.Suresh

[sureshgane]

oops bot are windows n/t.But in machine a it is oracle 8.0.4 in Machine B Oracle 8.1.6
Thanks

[bberg@rtnyc.com]

my guess... install 8.0.4 on machine B... shutdown oracle on both.

cold copy all files from A to B
startup database on B (to check it).
then do an upgrate to the database and the installation on B.


anyone else have another solution?

[sureshgane]

I cannot install 8.0.4.I need to install on 8.1.5 only.Which all files are to be copied????????
Thanks

[marist89]

Depending on database size, that't probably the best way.

Otherwise, you could export/import from the old to the new.

[marist89]

[QUOTE][i]Originally posted by sureshgane [/i]
[B]Which all files are to be copied????????
[/B][/QUOTE]
There are several threads on this forum explaining exactly what to do and which files to copy.

[sysdba]

The files you need to copy are:
1. init files (initSID.ora/configSID.ora, listener.ora,
tnsnames.lora, etc)
2. LOG files
3. CONTROL files
4. DATA files

[sambavan]

Try using RMAN and it would allow you to take the backup of your database and create another copy of the same one. There you don't even have to know what to copy and where it copy. RMAN would create you the test database for you.

Sam

[sureshgane]

What I followed was I copied physically the control files,init files,data files,log files from Machine A to Machine B.Then using Database Assistant Created the DataBase in MachineB.
Hope it will work.If my methodology is wrong let me know
Thanks
Suresh