After an uncontrolled failover, for Oracle SI and RAC complete the following procedure:
- Enable dSources and VDBs on the target engine.
dSources will be enabled but the VDBs/vPDBs will fail. - To enable VDBs, shutdown the database instance using SHUTDOWN ABORT.
- Remove all the mounts from the target environment with sudo privilege.
- List all the mounts on the target environment using the mount command.
- Run umount -lf <Delphix-mount> to remove the mounts.
For example: umount -lf /mnt/provision/VDBOMSR8A1718_FPX/datafile
- Remove all the stale oracle processes of the database instance using kill -p <process id>.
- Run ps -ef | grep “DATABASE INSTANCE to get all the running processes associated with the database instance.
For example ps -ef | grep VDBOMSR8A1718_FPX. This command list all the running processes, e.g. oracle 15236 9227 0 11:01 pts/0 00:00:00 grep --color=auto VDBOMSR8A1718_FPX - Run kill -p <process id> to kill all the running processes.
For example: kill -9 15236
- Run ps -ef | grep “DATABASE INSTANCE to get all the running processes associated with the database instance.
- Now enabling VDBs and VPDBs will be successful.