Troubleshoot Backup Failures to Recovery Service
If your database fails to backup to Recovery Service, use the information in this topic to troubleshoot the issue.
Typically, automatic backups to Recovery Service may fail because of configuration issues in the database VCN, or due to network connectivity problems between your database and Recovery Service.
These sections describe the common errors associated with backup failures, and provides troubleshooting information.
Connection timed out
Backups to Recovery Service may fail if the connection from a database client to Recovery Service could not be completed within the time out period.
How to Diagnose
Run the tnsping
command from the database client to verify connectivity between your database and Recovery
Service.
tnsping dbrs
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 26-APR-2023 06:09:46 Used parameter files: /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/sqlnetdb.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (FAILOVER = on) (CONNECT_TIMEOUT = 3) (RETRY_COUNT = 3) (TRANSPORT_CONNECT_TIMEOUT = 3) (ADDRESS_LIST = (LOAD_BALANCE = on) (ADDRESS = (PROTOCOL = TCPS)(HOST = sales-server)(PORT = 1421)) (ADDRESS = (PROTOCOL = TCPS)(HOST = sales-server)(PORT = 1421))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sales.example.com))) TNS-12535: TNS:operation timed out
- Probable Cause 4
- You could be using a custom DNS setup, which will lead to incorrect IP address resolution.
- Solution
- Perform a
nslookup
on the host names provided in thedbrsnames.ora
file. You can also obtain the host names when you run thetnsping
command. The IP address must match the IP addresses provided in the protected databasehosts.txt
file. You can download thehosts.txt
file from the protected database details page in the OCI Console.See, Downloading Protected Database Network Connection Details.
Subnet does not have any more available IP addresses
While creating a protected database, the work request may report a failed state for the associated Recovery Service subnet.
A problem occurred while creating the protected database resource
If there is a problem while creating a protected database, then you may encounter an error message that suggests to contact Oracle Support for assistance.
- Probable Cause
- Protected database creation may fail for unknown reasons.
- Solution
- You may retry later. If the problem persists, contact Oracle Support.
See, Submit a Service Request.
Parent topic: Troubleshooting