Skip to main content
Question

Oracle backup error

  • 1 December 2023
  • 2 replies
  • 381 views

any idea on the below error , 

 

Error Code: :18:183] Description: Failed with Oracle DB/RMAN error rRMAN-03009: failure of allocate command on ch1 channel at 12/01/2023 13:13:35 ORA-03113: end-of-file on communication channel ] Source: grb-srv-opr, Process: ClOraAgent

 

we restarted the server and services backup 4,5 backup ran sucessfully again we are facing same issue 

2 replies

Userlevel 6
Badge +15

Hi @jaleef 

Sorry for the delay… is this still an issue?


Research indicates ORA-03113 to be due to “The connection between the Client and Server process was broken. The cause may be that the database instance experienced a maintenance or unplanned outage, or that the Server process had a fatal error, or that the network connection was interrupted.”


Please refer to:https://docs.oracle.com/en/error-help/db/ora-03113/

Would bee keen to see what error is being reported in the rman.log at the time of failure if it’s still occurring.

Regards,

Chris 

Userlevel 3
Badge +13

Hello @Chris Hollis and @jaleef 

In my case I faced occasionally in the following major event during Oracle Database backup:
 

RMAN Script execution failed for instance [oracledb] with error [RMAN-03009: failure of backup command on ch1 channel at 08/07/2024 23:43:08 ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage RMAN-03009: failure of backup command on ch1 channel at 08/07/2024 23:43:08 ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage ].


Although, database backup job finished with status “completed” .
After failure, start another attempt right away and backup job completed successfully!

Is this something I need to worry?


Please for your feedback,
Nikos

Reply