I have the same configuration here.

For weekly backups, call a cmd/sh script file through cron or
ntscheduler
I am on NT so I use a command file

---------Command file start --------
echo on
SETLOCAL
if {%1}=={} @echo error script must be run with a parameter Syntax: %0
1 & goto :END_OF_FILE

for /f "Tokens=1-4 Delims=/ " %%a in ('date /t') do set
O_DATE=%%d_%%b_%%c& set

set O_RMAN=H:\oracle\product\10.2.0\db_1\bin\rman
set O_TARGET=SYS/[Email Address Removed] O_LOG=H:\oracle\product\10.2.0\db_1\scripts\rman_logs
set O_CMDFILE=H:\oracle\product\10.2.0\db_1\scripts
set O_SCRIPTSDIR=H:\oracle\product\10.2.0\db_1\scripts
%O_RMAN% target %O_TARGET% log '%O_LOG%\bkdbvector3_%O_DATE%.log'
cmdfile '%O_CMDFILE%\bkdbVECTOR.rcv'

--------Command file end ----------

-------RCV file start -------------
CONFIGURE RETENTION POLICY TO REDUNDANCY 6;
CONFIGURE CONTROLFILE AUTOBACKUP ON;

run
{
allocate channel ch1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=D:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt)';
BACKUP INCREMENTAL LEVEL 0 DATABASE;
sql "ALTER SYSTEM ARCHIVE LOG CURRENT";
backup archivelog all delete input;
backup current controlfile tag = 'database backup';
release channel ch1;
}
------RCV file end------------


For daily sweeps of the archive logs, command/sh script file through
cron or nt scheduler
I am on NT so I use a command file:

---------Command file start --------
echo on
SETLOCAL
for /f "Tokens=1-4 Delims=: " %%i in ('time /t') do set
O_TIME=%%i%%j%%k
set O_RMAN=H:\oracle\product\10.2.0\db_1\bin\rman
set O_TARGET=SYS/[Email Address Removed] O_LOG=H:\oracle\product\10.2.0\db_1\scripts\rman_logs
set O_CMDFILE=H:\oracle\product\10.2.0\db_1\scripts
set O_SCRIPTSDIR=H:\oracle\product\10.2.0\db_1\scripts
set O_DBNAME=dbname

%O_RMAN% target %O_TARGET% log '%O_LOG%\bkdbsweepvector_%O_DATE%.log'
cmdfile '%O_CMDFILE%\bkdbsweepvector.rcv'
---------Command file end --------

--------RCV file start --------------
CONFIGURE RETENTION POLICY TO REDUNDANCY 6;
CONFIGURE CONTROLFILE AUTOBACKUP ON;

run
{
allocate channel ch1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=D:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt)';
backup archivelog all delete input;
backup current controlfile tag = 'database backup';
release channel ch1;
}
----RCV file end

Good Luck!
Kathy

>>> "YIF " <oracledba-ezmlmshield-x27639990.[Email address protected]
2/27/2007 2:47:51 AM >>>
Dear All

I’m using Oracle 10g R2 RAC, my Database sits on storage device using
raw
devices, the Database is configured with ARCHIVELOG mode.
1. Now if I’m not using RMAN, how can I delete the archive files?
2. If they don’t get deleted, will the size of the archive files
keeps
increasing until it fills up the entire storage.


Regards





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page