How to restart a standby database after having issues with it and its primary
Good morning,
A little less than a year ago I came into the office and the application I work on was down. Turns out that the sys admin had to run a check disk and then the application started back up. But. In trying to figure out what was going on (thinking that the database was at fault) I errantly ran ‘recover managed standby database disconnect’ on the primary server instead of the standby.
After the check disk was run, everything seemed fine, but the sequence numbers on the standby and primary were out of sync. The primary was still sending backup files to the standby so I didn’t want to mess with it.