Online Backup Multiple Databases

From: Claudia Payer <Claudia.Payer_at_sued-data.de>
Date: Mon, 03 May 1999 11:37:28 +0100
Message-ID: <372D7C68.411E4485@sued-data.de>

I am running several Oracle instances on Unix machines (IBM AIX), and I want to create a backup script, which dynamically gets the tablespace names and the database files, put the tablespaces one after the other in backup mode (online backup), then does the backup of the files, and finally puts the tablespaces out of the backup mode. I only found examples for ONE database, with a lot of code and temp-files. The biggest problem I have is that servermanager can't read variables - something like "connect internal@$d" or "alter tablespace $t begin backup". Everything else seems to be clearly, looping for SIDs of started databases and so on.
Does anybody have a solution for this problem, or how did you cover the problem backing up multiple databases?
A little tip would be very welcome!
Claudia Payer
Sued-DATA
Munich

You can send me a mail to claudia.payer_at_sued-data.de

Received on Mon May 03 1999 - 05:37:28 CDT