I've done it a couple of ways - 1st way was using oracle export and then
backing up the files using TSM - had problems with the size of the export
file, and backup and recovery were slow and a multi-step process.  Required
constant monitoring during the recovery process.

I have a system now where I'm using the 3rd array copy to remove and mount a
copy of my data base file systems and backing that up - this is quick on
both the backup and recovery and I've used this method to move copies of the
production database to testing and so far, like the way it works.

Mike Walker



-----Original Message-----
From: David E Ehresman [mailto:deehre01 AT LOUISVILLE DOT EDU]
Sent: Monday, May 24, 2004 10:30 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Data base backup


Has anyone used rman to backup oracle data to a disk filesystem and
backed up the disk filesystem using standard tsm rather than using TSM
for Database?  If so, how has it worked for you?  Pros and cons?

David