In this section, we will cover specific topics around troubleshooting Dbvisit Standby version 9.
2. Creating a support package
One of the most important steps you should perform when logging a support call is to generate a support package.
This section will cover the process in more detail and show you how easy it is to create a support package.
2.1. Using the Command Line Interface (dbvctl)
When running Dbvisit Standby processes, the Process ID or "pid" is displayed in the header. In the example below, we can see the (pid 4085).
Now that we have the process id, we can create a support package with the command: dbvctl -d <ddc> -f support_package [-a pid=<pid>]
Unless you are aware of the specific PID process that is having a problem use this command: dbvctl -d <ddc> -f support_package. This would create a generic support package, collecting database, Dbvisit Standby configuration details required by the support team.
In the example below support, the package is created for process id 4085.
Once the support package is created in the DBVISIT_BASE/standby/support subfolder, you can upload this to the Dbvisit Support team to assist.
2.2. Using the Central Console
This section will show you how to create a support package using the Central Console.
There are two methods for creating a support package:
- On completion or failure of a task
- At the completion of each Active task or if any error is detected in the Central Console the option to create and then download the support package will be presented at the top of the task output.
- Using the Create Support Package option from the Active Task List menu (bottom bar)
- Using this option you can create a support package for a specific server (primary or standby) for a specific DDC file, or you can create a support package for a specific PID for a DDC file.
- The steps to do this is described using the images below:
Step 1: Click on "Create Support Package" (1), then select the Dbvisit Standby Configuration (DDC) (2) - see image below:
Step 2: Select the specific Host (on which the Support Package will be created) for the specific DDC (2) - see image below:
Step 3: If you want to create a support package for a specific PID (4 - below) specify the pid, otherwise, click on submit to create a generic support package.
Step 4: Download the support package (3) below. Once downloaded upload the support package to the support ticket if you have one logged with the Dbvisit Support team.
3. General Troubleshooting
3.1. Error opening file for writing
During an upgrade on a Windows-based system (if you are installing version 8.0.06 and above) you need to make sure that all Dbvisit Standby Schedules and Services are stopped prior to starting the installer.
If you get an error "Error opening file for writing" while running the Windows installer, you have not stopped the Dbvisit services, which means the dbvsmgr.exe application is in use and cannot be updated.
Stop the installer, stop the Dbvisit services and restart the installer.
3.2. Troubleshooting - "specify valid username and password"
When installing Dbvisit Standby version 9, it is important to make sure the user that is running the installer is in the Local Administrator group.
The user that is used to Run the dbvisit services - username and password are asked during the installer - must be in the following groups:
- Local Administrators
This user must also have the "Logon as a service" permission.
For more detail on how to do this please see the example below:
4. Graceful Switchover
This section will contain notes with regards to Graceful Switchover and possible errors and their fixes.
4.1. GS Fail due to NON-OMF redo logs and OMF redo logs expected
The following error is shown when performing a Graceful Switchover (GS) between two Windows-based Databases. This is the second Graceful Switchover, meaning a switch was performed between primary and standby, where the primary database was using ASM based storage and standby not (filesystem based). The second switch over is when we want to move from the filesystem based primary database to the ASM standby.
In this example, the primary database is running on Windows and using ASM storage with Oracle Managed Files configured (OMF)
The standby database was created on a Windows system using Filesystem Based storage.
But during the Standby Creation instead of having proper OMF configuration, the convert parameters where set.
Standby Server Details: Using ASM (this was the original primary)
Primary System Details: Using Filesystem (this was the original standby)
One way to show that these files are not OMF files are to add a new one, example below - you will see how the new OMF file names are different:
The solution in this scenario is to do the following:
- From the Primary which is currently using Filesystem Based Storage, remove (drop) redo log groups 1,2 and 3 which is not true OMF files, then recreate them as OMF redo (same as group 4 above)
- Remove the db_file_name_convert and log_file_name_convert parameters
- Run a number of log switches
- Send logs to the standby
- Apply logs
- Run Log Gap Report
- If the report shows 0 archive log gap, re-start the Graceful Switchover.