They have RMAN - it comes with Oracle but maybe is not installed.
You have three options:
1. perform offline backups
Stop Oracle instance, backup Oracle data files with TSM Backup/Archive
client, start the instance. The instance stop/start can be performed
within a single script with TSM client invokation in the middle or through
separate scripts using preschedulecmd/postschedulecmd.
2. online backups
Configure RMAN and use ITSM for Databases (former TDP for Oracle).
3. semi-online backups.
Alter tablespaces in backup mode, backup data files, alter tablespaces in
normal mode. This can be in-house grown solution without TDP but someone
have to verify all the scripts involved, document them, etc.
In all three options you can use many sessions. Even when backing up a
single filesystem TSM client can do it in parallel. TDP for Oracle also
can utilize many sessions.
Zlatko Krastev
IT Consultant
"Selva, Perpetua" <perpetua.selva AT RBCCM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
25.11.2002 18:10
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: TSM & Oracle db backup
HI
We have a client who wants to backup his oracle db using TSM.
However, they do not have TDP nor RMAN .
He is altering one tablespace at a time within one script and hoping
to achive multi-threading(multiple sessions) on TSM.
Is this possible? I think he could only achive one open session on TSM.
Please verify this and let me know how he could open up multiple sessions(
i
personally
think he needs TDP /RMAN)
any insights would be helpful
<font face="Times New Roman" size="3">
<p>------------------------------------------------------------------------------</p>
<p> This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in error,
please advise me (by return e-mail or otherwise) immediately.</p>
<p> Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas
aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation
ou copie de ce message ou des renseignements qu'il contient par une
personne autre que le (les) destinataire(s) désigné(s) est interdite. Si
vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement,
par retour de courriel ou par un autre moyen.</p>
<p>====================================================</p>
</font>
|