Hi All,
Using Oracle 11gR2 on RHEL 6.
I had to kill a rman job as it was very slow. It was taking a rman hot backup at tablespace level. There are 120 .dbf files and it backed till 60.
> BACKUP AS COMPRESSED BACKUPSET TAG 'PRODDAT_TBLSPC_BK' TABLESPACE PRODDTA;
My RMAN RETENTION - RETENTION POLICY TO REDUNDANCY 1
Crosschecked the backup;
CROSSCHECK BACKUPPIECE TAG = 'PRODDAT_TBLSPC_BK';
deleted the files;
DELETE BACKUP OF TABLESPACE PRODDTA;
When I run the backup job it starts from 61 number. How to clear all files and start the job from 1st file..
Thanks