ADSM-L

Re: [ADSM-L] Backing up ORACLE without using RMAN

2009-12-11 23:42:36
Subject: Re: [ADSM-L] Backing up ORACLE without using RMAN
From: Steven Harris <steve AT STEVENHARRIS DOT INFO>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sat, 12 Dec 2009 15:41:03 +1100
Well not with TDP for Oracle,  but it is possible using native oracle
facilities and the ba client

The following pseudo code is  from
http://www.adp-gmbh.ch/ora/admin/backup_recovery/hot_backup.html

for ts in tablespaces
 alter tablespace $ts begin backup 
<http://www.adp-gmbh.ch/ora/sql/alter_tablespace.html#begin_backup>
 for df in datafiles of $ts
   cp $df $SAVE/$df
   alter database datafile '$df' end backup 
<http://www.adp-gmbh.ch/ora/sql/alter_database.html#datafile_end_backup>
 end
 alter tablespace end backup 
<http://www.adp-gmbh.ch/ora/sql/alter_tablespace.html#end_backup>
end
alter system switch logfile 
<http://www.adp-gmbh.ch/ora/sql/alter_system.html#switch_logfile>
alter database backup controlfile to trace 
<http://www.adp-gmbh.ch/ora/sql/alter_database.html#backup_controlfile>


Replace the copy step with a dsmc backup or archive of the datafile.
Change the last line to alter database backup controlfile to 'filename'
and add a dsmc step to backup or archive that file name.

Give that a try.

Regards

Steve

Steven Harris
TSM Admin,
Employment Pending.... At last
Sydney Australia


Wanda Prather wrote:
No.


On Thu, Dec 10, 2009 at 9:38 AM, Mario Behring <mariobehring AT yahoo DOT 
com>wrote:


Hi all,

Can I configure TDP for Oracle to backup Oracle databases WITHOUT using
RMAN?

Mario

>
------------------------------------------------------------------------


No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.709 / Virus Database: 270.14.101/2555 - Release Date: 12/10/09 
06:41:00