cancel
Showing results for 
Search instead for 
Did you mean: 

suddenly oracle archive log backups are failing

Pinky472
Level 4

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

 

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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

View solution in original post

7 REPLIES 7

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
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).

YAG55
Level 4

Hi,

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

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
Moderator
Moderator
Partner    VIP    Accredited Certified

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)

thanks for your advise.

could you please advise few articles Marianne.

 

thanks in advance.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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

@Marianne , sure i will check with them. thanks for your advise.

 

have a nice day.