Dear Oracle fanatics,
Weve got a site which seems to give us the following error sporadically , is there anyone with the same experience and/or know how what to do or perhaps any leads to where to search would be very welcome.
Many thanks in advance !!
It should not be related to privileges or disk space as seen below :
sppaxdb02 # df -h
Filesystem size used avail capacity Mounted on
/ 187G 32G 156G 17% /
/dev 187G 32G 156G 17% /dev
/flashback 295G 138G 155G 48% /flashback
/zdbase/data1 266G 112G 151G 43% /zdbase/data1
/zdbase/index1 172G 50G 121G 30% /zdbase/index1
/zdbase/system 49G 30G 18G 63% /zdbase/system
proc 0K 0K 0K 0% /proc
ctfs 0K 0K 0K 0% /system/contract
mnttab 0K 0K 0K 0% /etc/mnttab
objfs 0K 0K 0K 0% /system/object
swap 58G 368K 58G 1% /etc/svc/volatile
/platform/sun4v/lib/libc_psr/libc_psr_hwcap2.so.1
187G 32G 156G 17% /platform/sun4v/lib/libc_psr.so.1
/platform/sun4v/lib/sparcv9/libc_psr/libc_psr_hwcap2.so.1
187G 32G 156G 17% /platform/sun4v/lib/sparcv9/libc_psr.so.1
fd 0K 0K 0K 0% /dev/fd
swap 58G 64K 58G 1% /tmp
swap 58G 48K 58G 1% /var/run
sppaxdb02 #
sppaxdb02 # ls -lhart
total 43734
drwxr-xr-x 4 root root 512 Oct 15 2013 ..
drwxr-xr-x 5 oracle dba 512 Oct 16 2013 MVF2
-rw-r----- 1 oracle dba 21M Apr 29 07:36 bkupcontrolfile.ctl
drwxr-xr-x 3 oracle dba 512 Apr 29 07:36 .
-rw-r----- 1 oracle dba 96K Apr 29 07:36 bkupspfile.ora
sppaxdb02 #
Alert and tracefile sample below :
Archived Log entry 71728 added for thread 1 sequence 52098 ID 0x7e57cb8 dest 10:
Tue Apr 29 08:48:00 2014
Errors in file /var/oracle/data/logs/impax/diag/diag/rdbms/mvf2/MVF/trace/MVF_arc1_2071.trc:
ORA-00314: log 13 of thread 1, expected sequence# 52100 doesn't match 52098
ORA-00312: online log 13 thread 1: '/usr/mvf/data/dbase/redo/redo_stdby13.log'
Tue Apr 29 08:48:00 2014
RFS[11]: Selected log 13 for thread 1 sequence 52100 dbid -91217615 branch 787868464
Tue Apr 29 08:48:01 2014
"/var/oracle/data/logs/impax/diag/diag/rdbms/mvf2/MVF/trace/MVF_arc1_2071.trc" 63 lines, 2458 characters
Trace file /var/oracle/data/logs/impax/diag/diag/rdbms/mvf2/MVF/trace/MVF_arc1_2071.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
ORACLE_HOME = /opt/oracle/current
System name: SunOS
Node name: sppaxdb02
Release: 5.10
Version: Generic_147147-26
Machine: sun4v
Instance name: MVF
Redo thread mounted by this instance: 1
Oracle process number: 31
Unix process pid: 2071, image: oracle@sppaxdb02 (ARC1)
*** 2013-10-15 13:27:44.362
*** SESSION ID:(311.1) 2013-10-15 13:27:44.362
*** CLIENT ID:() 2013-10-15 13:27:44.362
*** SERVICE NAME:() 2013-10-15 13:27:44.362
*** MODULE NAME:() 2013-10-15 13:27:44.362
*** ACTION NAME:() 2013-10-15 13:27:44.362
Redo shipping client performing standby login
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
*** 2013-10-15 13:27:44.706 4595 krsu.c
Logged on to standby successfully
Client logon and security negotiation successful!
DDE rules only execution for: ORA 312
*** 2014-01-23 10:15:48.476
----- 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-00322: log 13 of thread 1 is not current copy
ORA-00312: online log 13 thread 1: '/usr/mvf/data/dbase/redo/redo_stdby13.log'
DDE rules only execution for: ORA 312
*** 2014-04-29 08:48:00.534
----- 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-00314: log 13 of thread 1, expected sequence# 52100 doesn't match 52098
ORA-00312: online log 13 thread 1: '/usr/mvf/data/dbase/redo/redo_stdby13.log'
*** 2014-04-29 08:48:01.444
krsk_srl_purge_abandoned: No longer purgable SRL log 13 B-787868464.T-1.S-52100
ORA-16038: log 9 sequence# 20395 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 9 thread 1: '/usr/mvf/data/dbase/redo/redo09.log'
1
ORA-16038: log 9 sequence# 20467 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 9 thread 1: '/usr/mvf/data/dbase/redo/redo09.log'
1
MESSAGE_TEXT
--------------------------------------------------------------------------------
CNT
----------
ORA-16038: log 9 sequence# 20530 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 9 thread 1: '/usr/mvf/data/dbase/redo/redo09.log'
1
ORA-16038: log 9 sequence# 20665 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 9 thread 1: '/usr/mvf/data/dbase/redo/redo09.log'
MESSAGE_TEXT
--------------------------------------------------------------------------------
CNT
----------
1
172 rows selected.