Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Online Backup Multiple Databases
I uses a perl script, which get as an argument the Oracle-Instance, after
that, the complete Instance will be backed up to tape. The script itself
retrieves all the informations about the oracle instance. If I want to
backup multiple instances, I start the script a second or third time, with
the other instance as an argument. All Instances can be append to the tape.
Burkhard
Claudia Payer schrieb:
> 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 - 06:25:19 CDT