I’ve created a short video on manually starting up a RAC database that has a PDB with two custom services.
Earlier this week (10-April), I had done a Switchover from the 2node RAC database to a SingleInstance database.
Apparently, the error : alter pluggable database pdb open*ERROR at line 1:ORA-44309: unknown failureORA-44777: Pluggable database service cannot be started.
Continuing the series of posts on the RAC/ASM to SingleInstance/FileSystem DataGuard configuration … With both instances RAC1 and RAC2 running, I have redo shipping from both instances to the single instance STBY.(In my test server with 3 VMs, it takes a number of minutes to have all 3 instances running and communicating with each other … so there are spurious ORA and TNS errors until the 3 instances have stabilized.
Although Flashback Logs support the ability to execute a FLASHBACK DATABASE command, the actual Flashback also requires Redo to be applied.
The documentation on the Flashback Retention Target in 11.2 and 12.1 states that this parameter specifies an upper limit on how far the database may be flashed back.