Three nde RAC of 11.2.0.1 n Redhat 5.2. I have an offline tablespace, and there is no attention to use it. But in the alert.log file I keep seeing the message every 10 minutes:
Fri Feb 17 12:33:03 2012
Errors in file /u01/app/oracle/diag/rdbms/prdcch/prdcch1/trace/prdcch1_m000_27472.trc:
ORA-01135: file 9 accessed for DML/query is offline
ORA-01110: data file 9: '+DATA/prdcch/datafile/lcch1.ora'
. This is observed on all three nodes, but each node sees the error at different time but the same frequency.
Check the trace file and see:
Unix process pid: 23541, image: oracle@cchORdb1 (M000)
*** 2012-02-17 12:45:45.633
*** SESSION ID:(217.38833) 2012-02-17 12:45:45.633
*** CLIENT ID:() 2012-02-17 12:45:45.633
*** SERVICE NAME:(SYS$BACKGROUND) 2012-02-17 12:45:45.633
*** MODULE NAME:(MMON_SLAVE) 2012-02-17 12:45:45.633
*** ACTION NAME:(Monitor Tablespace Thresholds) 2012-02-17 12:45:45.633
DDE rules only execution for: ORA 1110
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
ORA-01135: file 9 accessed for DML/query is offline
ORA-01110: data file 9: '+DATA/prdcch/datafile/lcch1.ora'
DDE rules only execution for: ORA 1110
.....
I do not see any scheduled job at frequency of 10 minutes, nor a cron job access database every 10 minutes. What causes the accessing to the offline tablespace and how to stop it.
Thanks.