Script to compare two databases physical structure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Script to compare two databases physical structure

Hybrid View

  1. #1
    Join Date
    Jan 2003
    Posts
    78

    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.
    HTH.
    Shripad Godbole
    OCP DBA (8,8i,9i)

    "Let's document it and call it a feature."

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Depends on what evel you are talking about.


    1). Object level - Should be version control of DDL in DB, CVS, Source Safe etc.
    2). Schema Level - I think TOAD and OEM does a schema comparison (also for object level also). A bit of a bitch though when your database contains 150 schemas.
    3). Database level - init.ora paramters etc, select statements through unions and db links is one way.
    4). OS level - YOu'd have to write scripts to determine set up of boxes. You'd rarely find two boxes identical.
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Thumbs up

    Those three might help:

    Toad - (dba->compare schemas menu)
    Quest Change Manager http://www.quest.com/

    Embarcadero http://www.embarcadero.com/

    The first one is more functional and closer to the reality.

    Oracle OEM also has Change Manager tool.


    Hope that helps,

    clio_usa - OCP 8/8i/9i DBA

  4. #4
    Join Date
    Apr 2003
    Posts
    32
    See whether this suits u.....

    Looks little older version......

    http://www.think-forward.com/sql/chk2dbs.htm

  5. #5
    Join Date
    Mar 2003
    Location
    Dallas, TX
    Posts
    12
    I posted an integrated set of GUI tools to manage, monitor and tune the Oracle database. One of the many functions is to compare the physical structure of two schemas from the same or different databases with the capability to drill down to a comparison of two specific object descriptions side by side. The link is http://www.barsoft.net
    Michel Bartov
    http://www.barsoft.net/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width