Highlighted

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

 

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

Re: suddenly oracle archive log backups are failing

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

Re: suddenly oracle archive log backups are failing

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).
Highlighted

Re: suddenly oracle archive log backups are failing

Hi,

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

Re: suddenly oracle archive log backups are failing

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

Highlighted

Re: suddenly oracle archive log backups are failing

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)

Highlighted

Re: suddenly oracle archive log backups are failing

thanks for your advise.

could you please advise few articles Marianne.

 

thanks in advance.

Highlighted
Accepted Solution!

Re: suddenly oracle archive log backups are failing

@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

Highlighted

Re: suddenly oracle archive log backups are failing

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

 

have a nice day.