Oracle_91 (2/19/2014)
Hi LightVader,Thanks for the answer for scenario-1. I got to know the same thing from my peers. We need to break the mirroring and bring it online.
use master
go
alter database <dbname> set partner off;
go
restore database <dbname> with recovery;
go
As long as you keep in mind that if you do it that way, when the principal and witness come back online, you will have to go through the whole mirroring setup process again.