ADSM-L

Re: [ADSM-L] Can we use TSM for oracle database backup without using RMAN

2009-08-28 15:11:10
Subject: Re: [ADSM-L] Can we use TSM for oracle database backup without using RMAN
From: Richard Rhodes <rrhodes AT FIRSTENERGYCORP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 28 Aug 2009 15:10:14 -0400
We backup lots of db's without RMAN.

Here are some of the ways:

1)  Run an export to disk, then have the ba client backup the export file.
2) Run a Oracle Hot backup, where you backup the live files while the db is
in hot backup mode.  The procedure for a Hot backup is in the Oracle
manuals.
3) Shutdown Oracle and backup the db files.  This is a Cold backup.
4) If by "without RMAN" you mean without TDPO/RMAN, than run RMAN backups
to disk and have the ba client backup the files.






             Richard
             Mochnaczewski
             <Richard.Mochnacz                                          To
             ewski@STANDARDLIF         ADSM-L AT VM.MARIST DOT EDU
             E.CA>                                                      cc
             Sent by: "ADSM:
             Dist Stor                                             Subject
             Manager"                  Re: Can we use TSM for oracle
             <[email protected]         database backup without using RMAN
             .EDU>


             08/28/2009 01:09
             PM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>






Depending on your database requirements and availability, you can also shut
down the database and backup the flat files ( not an export )  using the
backup client. We do this if we want to move a database to another server
relatively quickly . This method only works if your Oracle is using flat
file and not logical volumes.

Rich



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Stephan26
Sent: Friday, August 28, 2009 1:04 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Can we use TSM for oracle database backup without
using RMAN


As mentionned, depending on Oracle, you could just export or dump to flat
files and backup from there...so you wouldn't need TDP for Oracle...

You'd have to be careful though.  You would want to do your dump using an
integrity check so that if any transaction are running while dumping, you
are not missing any parts.

+----------------------------------------------------------------------
|This was sent by durs AT rona DOT ca via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------



-----------------------------------------
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If
the reader of this message is not the intended recipient or an
agent responsible for delivering it to the intended recipient, you
are hereby notified that you have received this document in error
and that any review, dissemination, distribution, or copying of
this message is strictly prohibited. If you have received this
communication in error, please notify us immediately, and delete
the original message.

<Prev in Thread] Current Thread [Next in Thread>