personal oracle good for recovery practice
Date: Wed, 25 Jan 1995 19:57:57 GMT
Message-ID: <1995Jan25.195757.23364_at_tron.bwi.wec.com>
A tip - personal oracle is a great place to practice recovery for those who could not otherwise affect their 'real' oracle instances. You can simulate the worst case scenarios that strike the fear of God into any dba and have everything back in 5 minutes if you screw up!
I recommend that you install oracle, add some tablespaces and tables, etc. and shutdown and copy everything to a backup location. if you are short on disk space, you may only need to copy your control files,log file(s), data files, and all orawin\dbs\w*.*. I am 90% certain that this is all you need.
A 'gotcha' that hit me - it appears that 2 init.ora type files are out there and it depends on how you start oracle on which is used. if you use the transactioon manager, orawin/vs10/vs10.ini is used, if you use sql*dba then init.ora is used. This drove me nuts when I was switching to archivelog mode and changing the log_archive_format parm.
Remember, at worst all you have to do is restore files or re-install. Better here than for real! Received on Wed Jan 25 1995 - 20:57:57 CET