rman

From: Ravindra Basavaraja <ravindra_at_sentica.com>
Date: Fri, 01 Jun 2001 15:21:46 -0700
Message-ID: <F001.00318E3D.20010601151459@fatcity.com>

I am taking backup of a database on Archive mode using RMAN .

I am using the following script

run {

allocate channel c1 type disk format
'/u01/oracle/ravi/dfData_%d_%U_%p_%c';

        backup (database include  current controlfile);
        release channel c1;
        allocate channel c1 type disk format


'/u01/oracle/ravi/a/dfArch_%d_%U_%p_%c';

        backup (archivelog all delete input);
        release channel c1;

}

The above command should delete the archive files after backup.But what i notice
is that the archive files still exist after successful execution of the above script.
There were about more than 300 archive files and only 15 were deleted.I am attaching a
snopshot from the output of the above RMAN command.Can anyone tell me why this is
happeneing.What RMAN log files should I check?

Thanks

Ravindra

RMAN-08014: channel c1: specifying archivelog(s) in backup set RMAN-08504: input archivelog thread=1 sequence=5195 recid=1154 stamp=431274266
RMAN-08504: input archivelog thread=1 sequence=5196 recid=1155 stamp=431274273
RMAN-08504: input archivelog thread=1 sequence=5197 recid=1156 stamp=431274287
RMAN-08504: input archivelog thread=1 sequence=5198 recid=1157 stamp=431274315
RMAN-08504: input archivelog thread=1 sequence=5199 recid=1158 stamp=431274323
RMAN-08504: input archivelog thread=1 sequence=5200 recid=1159 stamp=431274329
RMAN-08504: input archivelog thread=1 sequence=5201 recid=1160 stamp=431274334
RMAN-08504: input archivelog thread=1 sequence=5202 recid=1161 stamp=431274339
RMAN-08504: input archivelog thread=1 sequence=5203 recid=1162 stamp=431274345
RMAN-08504: input archivelog thread=1 sequence=5204 recid=1163 stamp=431274350
RMAN-08504: input archivelog thread=1 sequence=5205 recid=1164 stamp=431274357
RMAN-08504: input archivelog thread=1 sequence=5206 recid=1165 stamp=431274389
RMAN-08504: input archivelog thread=1 sequence=5207 recid=1166 stamp=431274559
RMAN-08013: channel c1: piece 1 created
RMAN-08503: piece handle=/u01/oracle/ravi/a/dfArch_EARTS_0rcr9ei0_1_1_1_1 comment=NONE

RMAN-08525: backup set complete, elapsed time: 00:00:04
RMAN-08071: channel c1: deleting archivelog(s)
RMAN-08514: archivelog

filename=/u01/oracle/app/admin/earts/arch/arch_1_5195.arc recid=1154 stamp=431274266
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5196.arc recid=1155 stamp=431274273
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5197.arc recid=1156 stamp=431274287
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5198.arc recid=1157 stamp=431274315
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5199.arc recid=1158 stamp=431274323
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5200.arc recid=1159 stamp=431274329
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5201.arc recid=1160 stamp=431274334
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5202.arc recid=1161 stamp=431274339
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5203.arc recid=1162 stamp=431274345
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5204.arc recid=1163 stamp=431274350
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5205.arc recid=1164 stamp=431274357
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5206.arc recid=1165 stamp=431274389
RMAN-08514: archivelog
filename=/u01/oracle/app/admin/earts/arch/arch_1_5207.arc recid=1166 stamp=431274559

RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03022: compiling command: release

RMAN-03023: executing command: release
RMAN-08031: released channel: c1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ravindra Basavaraja
  INET: ravindra_at_sentica.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Jun 01 2001 - 17:21:46 CDT