Script to compare two databases physical structure
Anybody has a shell script or PERL script to compare physical structure of two databases (db1 and db2)? The script should take two arguments (db1 and db2) and compare datafiles and their sizes and display the differences. I am assuming here the mount points are same on two servers and these databases are on two different servers (say for example, production database on one server and standby database on another).
I need this script to check any differences between production and standby and email on call DBA to notify the differences, so that we keep both in sync as fast as possible and avoid any delay in applying transactions to standby.
Oracle 8.1.7.x and 9.0.1.x/9.2.0.x on Compaq Tru64 Ver 5.1.
OCP DBA (8,8i,9i)
"Let's document it and call it a feature."