Terry--

For the first one, you can get the list of the schema by adding the line:

report schema;

to the rman backup script. This may get you what you are looking for...

Dave

===================================
David Gold
Backup & Mass Storage Team
Software - Hardware - Training - Consulting
Cambridge Computer Services, Inc.
Tel: 617-787-1230 x208
Fax: 617-746-9811
dave AT camcom DOT com
www.cambridgecomputer.com
===================================

Message: 10
From: TWGIBBAR AT up DOT com
To: veritas-bu AT mailman.eng.auburn DOT edu
Date: Wed, 7 Feb 2001 08:46:32 -0600
Subject: [Veritas-bu] Script for gathering audit information

I'm looking for a script / commands that would easily gather the following
information to feed into an oracle audit.

Server Name
Database file name w/directory structure
Time backup starts (From client server)
Time backup ends  (From client server)



Thanks,
Terry
===================================
David Gold
Backup & Mass Storage Team
Software - Hardware - Training - Consulting
Cambridge Computer Services, Inc.
Tel: 617-787-1230 x208
Fax: 617-746-9811
dave AT camcom DOT com
www.cambridgecomputer.com
===================================
 ----------------------------------------------------------------------------
*Any ideas, suggestion or comments are mine alone, and are not of my
company*