8 Replies Latest reply on Jun 4, 2012 6:25 AM by Mrshah-Oracle

    standby log not applying

    Mrshah-Oracle
      Hi folks,

      Tried creating Data guard for the first time. Was able to successfully create a standby and on every log switch on primary database, a switch is seen on standby too..

      But the issue is, log's are not getting applied on standby db..

      SQL> archive log list;
      Database log mode              Archive Mode
      Automatic archival             Enabled
      Archive destination            F:\app\product\11.2.0\dbhome_1\RDBMS
      Oldest online log sequence     33
      Next log sequence to archive   0
      Current log sequence           38

      SQL> SELECT sequence#, first_time, next_time, applied
      2 FROM v$archived_log
      3 ORDER BY sequence#;

      SEQUENCE# FIRST_TIM NEXT_TIME APPLIED
      ---------- --------- --------- ---------
      *16 31-MAY-12 31-MAY-12 NO*
      *17 31-MAY-12 31-MAY-12 NO*
      *19 31-MAY-12 31-MAY-12 NO*
      *20 31-MAY-12 31-MAY-12 NO*
      *28 31-MAY-12 31-MAY-12 NO*
      *29 31-MAY-12 31-MAY-12 NO*
      *32 31-MAY-12 31-MAY-12 NO*
      *34 31-MAY-12 31-MAY-12 NO*
      *36 31-MAY-12 31-MAY-12 NO*
      *37 31-MAY-12 31-MAY-12 NO*
      *38 31-MAY-12 31-MAY-12 NO*

      11 rows selected.

      Also the alert log on strandby show's as...



      Alert log on standby:


      Thu May 31 23:30:43 2012
      RFS[18]: Assigned to RFS process 3380
      RFS[18]: Identified database type as 'physical standby': Client is ARCH pid 5780
      RFS[18]: Selected log 4 for thread 1 sequence 36 dbid 196575176 branch 784736843
      Thu May 31 23:30:45 2012
      Archived Log entry 9 added for thread 1 sequence 36 ID 0xbb7cbc8 dest 1:
      Thu May 31 23:30:45 2012
      RFS[19]: Assigned to RFS process 4968
      RFS[19]: Identified database type as 'physical standby': Client is LGWR ASYNC pid 5072
      Primary database is in MAXIMUM PERFORMANCE mode
      RFS[19]: Selected log 4 for thread 1 sequence 37 dbid 196575176 branch 784736843
      Thu May 31 23:30:46 2012
      RFS[20]: Assigned to RFS process 4996
      RFS[20]: Identified database type as 'physical standby': Client is ARCH pid 5192
      Thu May 31 23:30:47 2012
      Archived Log entry 10 added for thread 1 sequence 37 ID 0xbb7cbc8 dest 1:
      RFS[19]: Selected log 4 for thread 1 sequence 38 dbid 196575176 branch 784736843
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000010_0784736843.0001 (162 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_4996.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000010_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000010_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_4996.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000010_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000010_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:30:48 2012
      RFS[21]: Assigned to RFS process 4508
      RFS[21]: Identified database type as 'physical standby': Client is ARCH pid 5780
      Thu May 31 23:30:48 2012
      RFS[22]: Assigned to RFS process 1524
      RFS[22]: Identified database type as 'physical standby': Client is ARCH pid 5308
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000009_0784736843.0001 (198 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_4508.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000009_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000009_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_4508.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000009_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000009_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000008_0784736843.0001 (17296 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_1524.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000008_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000008_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_1524.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000008_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000008_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:30:51 2012
      RFS[23]: Assigned to RFS process 460
      RFS[23]: Identified database type as 'physical standby': Client is ARCH pid 5192
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000011_0784736843.0001 (65 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_460.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000011_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000011_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_460.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000011_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000011_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:30:52 2012
      RFS[24]: Assigned to RFS process 3456
      RFS[24]: Identified database type as 'physical standby': Client is ARCH pid 5780
      Thu May 31 23:30:52 2012
      RFS[25]: Assigned to RFS process 1936
      RFS[25]: Identified database type as 'physical standby': Client is ARCH pid 5308
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000012_0784736843.0001 (287 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_3456.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000012_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000012_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_3456.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000012_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000012_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000013_0784736843.0001 (10 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_1936.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000013_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000013_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_1936.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000013_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000013_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:30:56 2012
      RFS[26]: Assigned to RFS process 5084
      RFS[26]: Identified database type as 'physical standby': Client is ARCH pid 5192
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0784736843.0001 (193 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_5084.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_5084.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:30:57 2012
      RFS[27]: Assigned to RFS process 2404
      RFS[27]: Identified database type as 'physical standby': Client is ARCH pid 5780
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0784736843.0001 (8 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_2404.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_2404.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:36:48 2012
      RFS[28]: Assigned to RFS process 2988
      RFS[28]: Identified database type as 'physical standby': Client is ARCH pid 5192
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000010_0784736843.0001 (162 blocks)
      Thu May 31 23:36:49 2012
      RFS[29]: Assigned to RFS process 4152
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_2988.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000010_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000010_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      RFS[29]: Identified database type as 'physical standby': Client is ARCH pid 5308
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_2988.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000010_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000010_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:36:49 2012
      RFS[30]: Assigned to RFS process 4128
      RFS[30]: Identified database type as 'physical standby': Client is ARCH pid 5780
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000009_0784736843.0001 (198 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_4128.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000009_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000009_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_4128.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000009_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000009_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000008_0784736843.0001 (17296 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_4152.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000008_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000008_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_4152.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000008_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000008_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:36:51 2012
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_arc2_5596.trc:
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000038_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      ARC2: Error 19504 Creating archive log file to 'F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000038_0784736843.0001'
      ARCH: Archival stopped, error occurred. Will continue retrying
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_arc2_5596.trc:
      ORA-16038: log 4 sequence# 38 cannot be archived
      ORA-19504: failed to create file ""
      ORA-00312: online log 4 thread 1: 'F:\APP\ORADATA\STAN\SRL01.LOG'
      Thu May 31 23:36:53 2012
      RFS[31]: Assigned to RFS process 4340
      RFS[31]: Identified database type as 'physical standby': Client is ARCH pid 5192
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000011_0784736843.0001 (65 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_4340.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000011_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000011_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_4340.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000011_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000011_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:36:54 2012
      RFS[32]: Assigned to RFS process 3080
      RFS[32]: Identified database type as 'physical standby': Client is ARCH pid 5780
      Thu May 31 23:36:54 2012
      RFS[33]: Assigned to RFS process 3296
      RFS[33]: Identified database type as 'physical standby': Client is ARCH pid 5308
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000012_0784736843.0001 (287 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_3080.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000012_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000012_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_3080.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000012_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000012_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000013_0784736843.0001 (10 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_3296.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000013_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000013_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_3296.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000013_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000013_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:36:55 2012
      RFS[34]: Assigned to RFS process 3464
      RFS[34]: Identified database type as 'physical standby': Client is ARCH pid 5192
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0784736843.0001 (193 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_3464.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_3464.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:36:57 2012
      RFS[35]: Assigned to RFS process 6036
      RFS[35]: Identified database type as 'physical standby': Client is ARCH pid 5780
      Creating archive destination file : F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0784736843.0001 (8 blocks)
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_6036.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file f:\app\diag\rdbms\stan\stan\trace\stan_rfs_6036.trc:
      ORA-00270: error creating archive log F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0784736843.0001
      ORA-19504: failed to create file "F:\APP\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0784736843.0001"
      ORA-27056: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Thu May 31 23:37:09 2012
      Archived Log entry 11 added for thread 1 sequence 38 ID 0xbb7cbc8 dest 1:
      Archiver process freed from errors. No longer stopped


      confirmed that there is enough space and proper permission on the folder's..

      someone please suggest what could have gone wrong??

      Regards!
        • 1. Re: standby log not applying
          anand prakash - oracle
          Hi,

          Can you paste the output of the below sql from standby --

          select PROCESS,STATUS,THREAD#,SEQUENCE#,BLOCK#,DELAY_MINS from v$managed_standby where process like 'MRP%';


          Anand
          • 2. Re: standby log not applying
            mseberg
            Hello;

            Would look at archive destination on the Standby. Is it correct? Do you have enough disk/FRA space for it?

            Check this parameter on your Standby

            db_recovery_file_dest_size


            Best Regards

            mseberg
            • 3. Re: standby log not applying
              CKPT
              Hello,

              Are you using FRA or not?

              clear the older applied archives from the Archive destination and keep some free space in that mount point,
              if you using FRA post below output.

              >
              set lines 100
              col name format a60
              select     name
              ,     floor(space_limit / 1024 / 1024) "Size MB"
              ,     ceil(space_used / 1024 / 1024) "Used MB"
              from     v$recovery_file_dest
              order by name
              /
              • 4. Re: standby log not applying
                Mrshah-Oracle
                Hi,

                Please find the output...

                SQL> select PROCESS,STATUS,THREAD#,SEQUENCE#,BLOCK#,DELAY_MINS from v$managed_st
                andby where process like 'MRP%';

                no rows selected


                SQL> show parameter db_recovery_file_dest_size;

                NAME TYPE VALUE
                ----------------------------------------------------------------
                db_recovery_file_dest_size big integer 0


                Haven't configured FRA, here's the output...


                SQL> select     name
                *,     floor(space_limit / 1024 / 1024) "Size MB"*
                *,     ceil(space_used / 1024 / 1024) "Used MB"*
                from     v$recovery_file_dest
                order by name
                /

                NAME Size MB UsedMB
                0 0


                There is enough space on disk... Please suggest how can we resolve this issue.

                Warm Regards!
                • 5. Re: standby log not applying
                  mseberg
                  Hello again;

                  Fair enough, thanks for the details.

                  Can you post for both Primary and Standby the settings for this parameters?

                  db_unique_name
                  LOG_ARCHIVE_DEST_1
                  LOG_ARCHIVE_DEST_2
                  LOG_ARCHIVE_DEST_STATE_1
                  LOG_ARCHIVE_DEST_STATE_2
                  standby_file_management

                  If the Standby DEST is not 2 please post that instead. I'm thinking one of the Key Parameters must be OFF.

                  If Oracle 11R2 then Oracle doc E10700-02 section "3.1.4 Set Primary Database Initialization Parameters" and "3.2.3 Create a Parameter File for the Standby Database"
                  should shake it out, I asked for the most likely ones only.

                  OR

                  I have short notes here :

                  http://www.visi.com/~mseberg/data_guard_on_oracle_11_step_by_step.html


                  Best Regards

                  mseberg

                  Edited by: mseberg on Jun 1, 2012 12:27 PM
                  • 6. Re: standby log not applying
                    Mrshah-Oracle
                    Thanks for the reply mseberg..

                    Please find the output from both the database:


                    db_unique_name prod
                    log_archive_dest_1
                    log_archive_dest_2 service=stan async valid_for=(online_logfile,primary_role) db_unique_name=stan
                    log_archive_dest_state_1 enable
                    log_archive_dest_state_2 ENABLE
                    standby_file_management MANUAL


                    db_unique_name stan
                    log_archive_dest_1
                    log_archive_dest_2 service=prod ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=prod
                    log_archive_dest_state_1 enable
                    log_archive_dest_state_2 enable
                    standby_file_management AUTO


                    Please suggest what could have gone wrong? I can see logs number's switching in standby not they are not getting applied..


                    Regards!
                    • 7. Re: standby log not applying
                      mseberg
                      Hello again;

                      So I both servers log_archive_dest_1 is not set?

                      The Oracle example is

                      Primary

                      LOG_ARCHIVE_DEST_1= 'LOCATION=/arch1/chicago/VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=chicago'

                      Standby

                      LOG_ARCHIVE_DEST_1='LOCATION=/arch1/boston/VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=boston'



                      If a fast recovery area was configured (with the DB_RECOVERY_FILE_ DEST initialization parameter) and you have not explicitly configured a local archiving destination with the LOCATION attribute, Data Guard automatically
                      uses the LOG_ARCHIVE_DEST_1 initialization parameter (if it has not already been set) as the default destination for local archiving. Also, see Chapter 15 for complete LOG_ARCHIVE_DEST_n information.


                      My take is since you are not using FRA this parameter is not defined by default. I would probably set it on both, but frankly I'm not sure this will solve your issue. If it does I would sure like to know about it so i can add it to my notes.

                      Not related to your issue

                      Would consider setting standby_file_management to 'Auto' on both.

                      Would consider setting log_archive_dest_state_2 to 'DEFER' on the Standby.

                      Best Regards

                      mseberg

                      Would
                      1 person found this helpful
                      • 8. Re: standby log not applying
                        Mrshah-Oracle
                        Thanks a lot for your help mseberg .... It's on my home env, i'll check if it works... and let you know..