Topic: 1z0-083 topic 1 question 84

Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created.
You want to recover PDB1 to Restore Point R1.
How do you achieve this?

A.
Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.
B.
Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.
C.
Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
D.
Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.
E.
This cannot be done due to the lack of a clean restore point.

Re: 1z0-083 topic 1 question 84

In 19c, you can actually flashback a PDB from a restore point even if it's not clean:

When using restore points, you can perform a flashback database operation either to a CDB restore point, PDB restore point, PDB clean restore point, or PDB guaranteed restore point.

https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing-flashback-dbpitr.html#GUID-C1215E86-9A7B-4EC9-9777-2A18BD627394

Following on the same page, the procedure is described, which suggests the right answer to be D

Re: 1z0-083 topic 1 question 84

I agree. tested in Lab.
D - CORRECT

  • ald85
  • New member
  • Offline

Re: 1z0-083 topic 1 question 84

I think E

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/FLASHBACK-DATABASE.html#GUID-BE0ACF9A-BC13-4810-B08B-33326440258B

PLUGGABLE
Specify PLUGGABLE to flash back a PDB. You must specify this clause whether the current container is the root or the PDB you want to flash back.
Restrictions on Flashing Back a PDB
You cannot flash back a proxy PDB.
If the CDB is in shared undo mode, then you can only flash back a PDB to a clean PDB restore point. Refer to the CLEAN clause of CREATE RESTOREPOINT for more information.

Re: 1z0-083 topic 1 question 84

But that's a 12.2 doc page: in 19c, and I believe in 18c too, you apparently can do that, while connected to CDB via RMAN:

https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing-flashback-dbpitr.html#GUID-C1215E86-9A7B-4EC9-9777-2A18BD627394

Re: 1z0-083 topic 1 question 84

I agree. tested in Lab.

Re: 1z0-083 topic 1 question 84

not true, sorry

Re: 1z0-083 topic 1 question 84

E, this is my test lab.
FLASHBACK PLUGGABLE DATABASE PDB2 TO RESTORE POINT R1;

FLASHBACK PLUGGABLE DATABASE PDB2 TO RESTORE POINT R1
*
ERROR at line 1:
ORA-39883: Restore point R1 for pluggable database PDB2 is not a clean pluggable
database restore point.

  • Mcf23
  • New member
  • Offline

Re: 1z0-083 topic 1 question 84

D correct
ORA-39883: Restore point string for pluggable database string is not a clean pluggable database restore point.
Cause: For a pluggable database using shared undo, there was an attempt to flashback pluggable database "in SQL" without a clean pluggable database restore point. The specified restore point was not a clean pluggable database restore point.

Action: DO ONE OF THE FOLLOWING: - Issue flashback pluggable database in RMAN. - Issue the SQL flashback pluggable database command to flashback to a clean pluggable database restore point. - Turn on local undo mode for the pluggable database. The SQL flashback pluggable database command can always be used to flashback a pluggable database using local undo.

Re: 1z0-083 topic 1 question 84

E is correct. it uses shared undo as local undo is set to false. and clean_pdb_restore point must be applied (must be set to yes)

  • _gio_
  • New member
  • Offline

Re: 1z0-083 topic 1 question 84

Based on documentation you must conneto to CDB root with rman and flashback pdb

Re: 1z0-083 topic 1 question 84

E - based on earlier comments, and test

Re: 1z0-083 topic 1 question 84

SQL> flashback pluggable database pdb1 to restore point r1;
flashback pluggable database pdb1vlt to restore point r1
*
ERROR at line 1:
ORA-39883: Restore point R1 for pluggable database PDB1 is not a clean
pluggable database restore point.

  • vkra
  • New member
  • Offline

Re: 1z0-083 topic 1 question 84

Answer : D

Re: 1z0-083 topic 1 question 84

Finished flashback at 2028-03-32:22:10:24
RMAN>

Re: 1z0-083 topic 1 question 84

you can flashback either by using RMAN or SQL.

So the answer most probably is E, cause many others are correct also and you can select just one of them.

Re: 1z0-083 topic 1 question 84

not only RMAN,  SQL too

Re: 1z0-083 topic 1 question 84

I'm fairly certain it's D.

Re: 1z0-083 topic 1 question 84

Answer : D
Here Two point need to consider 1. shared undo mode 2. Clean restore point.
In a CDB that uses shared undo, one set of tablespaces is shared by all PDBs. Undo data for multiple PDBs may be mixed within the undo tablespaces and even within individual data blocks. Therefore, to perform a flashback database operation for a PDB, RMAN automatically uses an auxiliary instance to restore shared undo tablespaces and certain tablespaces in the root and then recovers data to the required point in time. This process may involve restoring backups for a relatively small amount of data. When you perform a flashback database operation on a PDB to a clean PDB restore point, no auxiliary instance or restoring of backups is required.

By default, the auxiliary instance is created in the FRA. You can use the AUXILIARY DESTINATION clause in the FLASHBACK DATABASE command to specify an alternate location for the auxiliary instance.

Here in this question AUXILIARY DESTINATION clause is omitted(which is optional) so this RMAN command from CDB$ROOT will execute.

Re: 1z0-083 topic 1 question 84

D is correct.
For a CDB that uses Shared undo only RMAN can be used to flashback a PDB because an auxiliary instance must be created to accomplish this.

Re: 1z0-083 topic 1 question 84

E
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/using-flasback-database-restore-points.html#GUID-34C48821-B29D-4A2E-94DE-CD97CFA7784E

Re: 1z0-083 topic 1 question 84

For CDBs that use shared undo, a Flashback Database operation to a clean PDB restore point is faster than a Flashback Database operation to an SCN or other restore points that are not clean PDB restore points. This is because RMAN does not need to restore any backups while performing a flashback operation to a clean PDB restore point.

Re: 1z0-083 topic 1 question 84

ald85 and michael_live  are right - you CANNOT flashback PDB without CLEAN restore point if there is SHARED UNDO mode.

Re: 1z0-083 topic 1 question 84

If you try to reproduce this test case, then you will get ora-39883 from SQL*Plus (both PDB and CDB$ROOT), RMAN-07536 while connected to PDB and you'll be succeeded performing "flashback pluggable database..." from CDB$ROOT.

So for me correct answer is D.

Re: 1z0-083 topic 1 question 84

I guess the difference between your test and others' is the DB version, if you're using 18c or higher.