Hi DBAs,
WIndows 2012 Server, 11.2.0.4.
Backups run successful till last week. from then on wards backups are failing due to RMAN errors. Could you give some tips to avoid this error pls.
rman configuration :
RMAN>
RMAN configuration parameters for database with db_unique_name RATOR are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'M:\RMAN_BKP\snapcf1_RATOR.f';
Script -
RMAN> run
2> {
3> ALLOCATE CHANNEL a1 DEVICE TYPE DISK FORMAT 'M:\RMAN_BKP\%U';
4> ALLOCATE CHANNEL a2 DEVICE TYPE DISK FORMAT 'M:\RMAN_BKP\%U';
5> sql "alter system archive log current";
6> crosscheck backup;
7> crosscheck backup of database;
8> crosscheck archivelog all;
9> delete force noprompt obsolete;
10> delete force noprompt obsolete orphan;
11> delete force noprompt expired backup;
12> sql "alter system archive log current";
13> Backup as compressed backupset incremental level 0 TAG = DB_FULL database;
14> sql "alter system archive log current";
15> backup AS COMPRESSED BACKUPSET archivelog all delete input TAG=ARCHIVE_LOG;
16> copy current controlfile to 'M:\RMAN_BKP\c_DB_%d_%s_%T.cf';
17> sql "alter system archive log current";
18> release channel a1;
19> release channel a2;
20> }
Error-
=====
channel a2: starting piece 1 at 2014-09-09-02:28:52
RMAN-03009: failure of backup command on a1 channel at 09/09/2014 04:00:01
ORA-19502: write error on file "M:\RMAN_BKP\8HPI1JMF_1_1", block number 1887617 (block size=8192)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
ORA-19502: write error on file "M:\RMAN_BKP\8HPI1JMF_1_1", block number 1887233 (block size=8192)
ORA-27070: async read/write failed
channel a1 disabled, job failed on it will be run on another channel
released channel: a1
released channel: a2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on a2 channel at 09/09/2014 04:27:29
ORA-19502: write error on file "M:\RMAN_BKP\8IPI1JMM_1_1", block number 2476929 (block size=8192)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
ORA-19502: write error on file "M:\RMAN_BKP\8IPI1JMM_1_1", block number 2476801 (block size=8192)
ORA-27070: async read/write failed
Thanks,
Hari