Copy software or data

[sirron]

I have a production AIX 5.1 box that has an ORACLE database on it. Then I have a test environment AIX 5.1 box this is for testing only. I want to take all of the ORACLE data/software from the production AIX and copy that to my AIX 5.1 TEST box. If this can be done will it work right?

How can this be done. And is there any documents that you can point me to on the internet?

Thank you in advance

 

[raztaboule]

tar cvf / tar xvf
you have to copy
the fs where $ORACLE_BASE is located .
all the datafile ( conected as system under oracle : select file_name from dba_datafiles ) and controlfiles ( look in initora)
look in the inittab there is on line related to oracle.
copy the file located under /etc that are call by inittab.
be sure to restore the datafiles in the same location.
create the directory where oracle logs ( look in initora )
change listener.ora according to the new hostname.
and don't forget to create and oracle user )

 

[raztaboule]

i forgot to mention the redo logs files you can find the location somewhere in oracle in a dba view .

 

[trifo]

Another possibility is creating an mksysb backup of the production system and clone it to the test system. Assuming there is no relevant data on the test system and is similar hardware (can run on the same config).

Remember to
1) stop oracle and everything before creating mksysb
2) use savevg for user VG-s (all except rootvg).
3) disconnect test box while restoring from mksysb backup to avoid IP config problems (the restored system will have the same IP address and hostname as the production system) and set the IP config of test system after restoring.
4) check Oracle listener config on the restored test system (and every other IP and hostname related stuff)

and stuff...

--Trifo

 

[sirron]

Is it possible to do a fresh install of oracle and copy the database from production to the test environment. This way I don't have to mess with the IP address

 

[KenCunningham]

Yes. And this will also enable you to copy the database and change it's name at the same time, to avoid confusion. See Thread186-429885

This has proved invaluable to me several times. Sybaseguru's post is worth a star on it's own. Regards.