Archive backup of all the databases from a specific linux server was completing successfully with 0 bytes of data backed up.
[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
Nice solution, I have been following all your solutions. Most of them I faced and solved but what ever the information you shared is clear. be blessed.
ReplyDeleteinteresting article like yours.