Friday, March 14, 2014

Zero KB Archive backup

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


1 comment:

  1. 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.

    interesting article like yours.

    ReplyDelete

Hi, Just in-case, your comment will be published only after my approval.