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
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/
Comments