AppSync: Oracle Backup stops responding and fails when archive log disk is full

Summary: AppSync should fail the job earlier when it detects the Oracle database is already in hot-backup mode, but AppSync continues to try to copy archive logs. AppSync stops responding for about 1 hour, as archive log is full. ...

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

AppSync should fail the job earlier when it detects the Oracle database is already in hot-backup mode, but AppSync continues to try to copy archive logs. AppSync stops responding for about 1 hour, as archive log is full.

The AppSync Events show:      
 
2021-04-26 04:30:43.494,Create local copy, ORCL_000013,<AppSync server>,AppSync was unable to quiesce the Oracle database: orcl. Ensure that it is not quiesced already and that it is open in read-write mode.

2021-04-26 04:31:26.233,Create archLogs local copy, MILE_000003,xxx,Completed execution of a service cycle in <Service plan name>
 
Notice the time gap:     

2021-04-26 05:30:45.294,Create local copy, ORCL_000101,<AppSync server>,One or more archive logs for database 'orcl' failed to be written. As a result, the created copy is not consistent. Check if the archive log destinations are correct and contain proper permissions and have the required free space.

Agent log that ends with _beginBackup.log on Source host shows:      
 
2021-04-26 04:29:29.942 oracle.py[5007]:_execSql() SQLresult: ORA-01146: cannot start online backup - file 1 is already in backup
...
2021-04-26 04:29:31.833 oracle.py[6213]:getSqlQueryTimeout() SqlQueryTimeout value : : 3600
2021-04-26 05:29:31.915 oracle.py[6213]:getSqlQueryTimeout() SqlQueryTimeout value : : 360

Cause

AppSync software issue.

Resolution

A hotfix exists for this issue. Contact Dell Technical Support and note this article ID when calling.

Additional Information

The hotfix prevents triggering of endBackup if there is any file already in backup. This prevents the service plan from not responding for an hour.

Products

AppSync, AppSync
Article Properties
Article Number: 000187684
Article Type: Solution
Last Modified: 22 Oct 2024
Version:  5
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.