Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the P

ALTER PLUGGABLE DATABASE ALL OPEN alone is insufficient because the CDB itself must first be opened with RESETLOGS after a FLASHBACK DATABASE operation before PDBs can be opened.

ALTER DATABASE OPEN without the RESETLOGS clause is not valid after FLASHBACK DATABASE; Oracle requires RESETLOGS because the redo log sequence has changed.

ALTER DATABASE OPEN RESETLOGS alone opens the CDB but leaves all PDBs in MOUNTED state, preventing any user access or DML against the PDB schema.

After FLASHBACK DATABASE, ALTER DATABASE OPEN RESETLOGS (command 3) is mandatory because the operation invalidates the current redo log sequence and requires a new incarnation. In a multitenant CDB, PDBs do not automatically open when the CDB opens, so ALTER PLUGGABLE DATABASE ALL OPEN (command 1) must follow to make the flashed-back PDB accessible for updates.

Commands 1 and 2 bypass the required RESETLOGS clause; ALTER DATABASE OPEN without RESETLOGS is rejected by Oracle after a flashback, making this combination invalid.