Forum Discussion

Pinky472's avatar
Pinky472
Level 4
6 years ago
Solved

suddenly oracle archive log backups are failing

Hello Techs,

hope everyone is doing well. I need your help.

in my environment , suddenly oracle archive log backups are failing with error code 6. but sometimes it is getting successful. not sure why it is failing intermittently.

however databse backups are running fine.

master and media server : netbackup appliance version 8.1.1

mixed clients : operating system is liunx and windows. version 8.1.1 and 7.7.3

please shed some light if you have any ideas

 

8
Linux
  • Marianne's avatar
    Marianne
    6 years ago

    Pinky472 

    That is honestly something that your DBA must do. 

    I have typed this into Google:

    man-04004: error from recovery catalog database: ORA-12170: TNS: connect time out

    The result is 5 or 6 links.

    Your DBA needs to read through the links to see if any of it is applicable. 

    Seeing that more than one Oracle client is having the same issue, the problem seems to be with the RMAN Catalog database and/or associated TNS Listener service. 

7 Replies

Sort By
  • Marianne's avatar
    Marianne
    Level 6
    6 years ago
    Please ask the dba for rman output/log.
    Also check dbclient log on the client (log folder does not exist by default, it needs to be created with 777 permission).
    • Pinky472's avatar
      Pinky472
      Level 4
      6 years ago

      i can see the below eeror from rman log for windows and linux oracler clients.

      please could you provide some light on this.

      INF - connected to target database: PROD (DBID=4224663781)
      INF - RMAN-00571: ===========================================================
      INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      INF - RMAN-00571: =========================================================
      INF - RMAN-04004: error from recovery catalog database: ORA-12170: TNS:cconnect time out

      • Marianne's avatar
        Marianne
        Level 6
        6 years ago

        This is not a NetBackup problem.Your Oracle team needs to troubleshoot this:

        RMAN-04004: error from recovery catalog database: ORA-12170: TNS:cconnect time out

        (Seems there is a number of useful links if you Google this error)

  • YAG55's avatar
    YAG55
    Level 4
    6 years ago

    Hi,

    Please check the overlap of the backup windows between database backups policy and archive backup policy.