We're here to help!

Catalog archivelog and backup pieces hang

Follow

Read our docs While running CSD after transferring the backup pieces to standby, RMAN catalogs the backup pieces and the same happens before applying the archivelogs in the standby.

Problem Details

Problem Statement

RMAN Catalog hangs while cataloging backup pieces or archivelogs

Applicable Error Code

It just hangs and terminates the Dbvisit Error Code: 2044

Affected Versions

Dbvisit Standby V8 and Oracle 12.1

Affected Platforms

Platform Independent

Description

While running CSD after transferring the backup pieces to standby, RMAN catalogs the backup pieces and the same happens before applying the archivelogs in the standby. The CSD might just hang for a long time without doing anything, If this archivelog apply it might just throw out an Error Code:2044

Solution

The solution is quite simple, this can happen when we have set db_recovery_file_dest, We can just change it to log_archive_dest_1 to workaround the issue, This needs to be done in the standby database.

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='' SCOPE=SPFILE;
ALTER SYSTEM SET log_archive_dest_1='location=/u02/oradata/cuddle/archive' scope=spfile;

Restart the standby database after setting the parameters.Please note this can happen due to various other issues such as network latency or server slowness

We highly recommend upgrading to latest Version of Dbvisit Standby before implementing this solution

The latest version changes can be viewed using the below link. http://www.dbvisit.com/products/standby_latest_changes_v8/
Have more questions? Submit a request

Comments