I have been wondering for a while whether we could export awr data from a 10gr2 database (awrextr.sql) and load it into an 11gr2 database (awrload.sql). I got to test this yesterday and it works fine. I was able to do the awrload.sql with No errors. Afterwords i even ran the 11gr2 awrrpti.sql script to generate awr reports using this data. It produces awr reports, but as one would expect, the portions where the data is not available in 10gR2 (eg: wait event histograms), the report just says “no data exists for this section of the report”.
I find it convenient to install the oracle 11gr2 rdbms on Oracle Enterprise Linux 5, running as a virtual host using VirtualBox VM (That way i dont have to go through the pains of installing it on Ubuntu Linux, which is unsupported). I use this database on a daily basis for testing different oracle functionality.
I use the following virtualbox command line commands to start and stop the virtual machine. It is much faster that booting up the operating system and then starting oracle.
To stop the virtual machine(I have named the VM OEL7) , in its current state (With the oracle rdbms running)
$ VBoxManage controlvm OEL7 savestate
To start it
$VBoxManage startvm OEL7
It takes about 10 seconds to start it.
To make a clone of the Virtual Machine to a entirely new location. First shutdown the virtual machine and then
$VBoxManage clonevm OEL7 –options keepallmacs –name OEL7E –basefolder “/media/ExternalDrive/vimage2”
The –basefolder can be specified to be a new location on disk to create the new image.