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
Printable View
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
oops bot are windows n/t.But in machine a it is oracle 8.0.4 in Machine B Oracle 8.1.6
Thanks
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?
I cannot install 8.0.4.I need to install on 8.1.5 only.Which all files are to be copied????????
Thanks
Depending on database size, that't probably the best way.
Otherwise, you could export/import from the old to the new.
There are several threads on this forum explaining exactly what to do and which files to copy.Quote:
Originally posted by sureshgane
Which all files are to be copied????????
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
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
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