- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
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..