Archive backup of all the databases from a specific linux server was completing successfully with 0 bytes of data backed up.
What was causing this??
No idea until we checked the seaudit log. The inet service was restarted from an local admin account, from then onwards the DP processes were lacking the root access rights which prevented from reading the data.
Example Error Log :
[Normal] From: BSM@cellsrv01.in.com "dbclient01_DB01_AR" Time: 03/03/14 07:15:23
Backup session 2014/03/03-86 started.
[Normal] From: BSM@cellsrv01.in.com "dbclient01_DB01_AR" Time: 03/03/14 07:23:36
OB2BAR application on "dbclient01.in.com" successfully started.
[Normal] From: BSM@cellsrv01.in.com "dbclient01_DB01_AR" Time: 03/03/14 07:23:36
OB2BAR application on "dbclient01.in.com" disconnected.
[Normal] From: BSM@cellsrv01.in.com "dbclient01_DB01_AR" Time: 03/03/14 07:23:37
Backup Statistics:
Session Queuing Time (hours) 0.00
-------------------------------------------
Completed Disk Agents ........ 0
Failed Disk Agents ........... 0
Aborted Disk Agents .......... 0
-------------------------------------------
Disk Agents Total ........... 0
================================
Completed Media Agents ....... 0
Failed Media Agents .......... 0
Aborted Media Agents ......... 0
-------------------------------------------
Media Agents Total .......... 0
================================
Mbytes Total ................. 0 MB
Used Media Total ............. 0
Disk Agent Errors Total ...... 0
What was causing this??
Is there any transactions happening in these DBs or not??
Any patching on server or DB that prevents the data transfer??
Why DP doesn't err anything??
No idea until we checked the seaudit log. The inet service was restarted from an local admin account, from then onwards the DP processes were lacking the root access rights which prevented from reading the data.
05 Mar 2014 04:47:42 D SURROGATE useradm1 Read 69 2 USER.oradba /opt/omni/lbin/inet 198.10.10.2 root
Solution:
Once again the inet daemon was restarted from root.
Commands to restart the DP inet service from Linux client:
#/etc/init.d/omni stop
#/etc/init.d/omni start