Re: Script to Document a Database
Date: Thu, 25 Feb 2010 08:26:38 -0500
Message-ID: <ae2c46ba1002250526p22efbb8ej13add92fcbe863c3_at_mail.gmail.com>
As a really distant aside, have you ever looked at the output of
alter database backup controlfile to trace;
Lot of useful things in there for documentation purposes. Not the prettiest format by any means, but nonetheless, very useful.
On Thu, Feb 25, 2010 at 7:59 AM, Jay Hostetter <hostetter.jay_at_gmail.com>wrote:
> I have a script that we run weekly on our databases. It creates some basic
> documentation about the database (users, tablespaces, segments,
> v$parameters, jobs etc.). I was going to update this script to inlcude more
> information, but I thought I would first check to see if there are any good
> scripts out there that do this sort of thing. I didn't find too much when I
> was searching around. IIRC RDA creates a nice HTML document (it's been
> quite some time since I ran it). I was interested in pulling the
> information remotely - not using RDA locally on each box, so I have ruled
> out RDA. I don't want to be too intruisive on these database servers. I
> just wanted some handy-dandy documentation for reference without reinventing
> the wheel.
>
> Thank you,
> Jay
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 25 2010 - 07:26:38 CST