Exercise setting the diagnostic destination

Table of Exercises

Exercise 1.1 Putting a Database in ARCHIVELOG Mode . . . . . . . . . . . . . . . . . . . . . . . . . 31

Exercise 2.2 Recovering the Database from the Loss of All Data Files . . . . . . . . . . . . . 67

Exercise 2.3 Performing a Point-in-Time Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81

Exercise 5.2 Perform a Point-in-Time Recovery with RMAN . . . . . . . . . . . . . . . . . . . . . 211

Exercise 6.1 Using the REPORT Command . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 245

Exercise 8.2 Using Flashback Query . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 371

Exercise 8.3 Using Flashback Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 382

Exercise 10.1 Exporting a Transportable Tablespace Set . . . . . . . . . . . . . . . . . . . . . . . . 475

Exercise 10.2 Shrinking a Segment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .494

Exercise 12.2 Connecting to a PDB Using SQL*Plus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 559

Exercise 13.1 Using Data Pump to Migrate a Non-CDB into a PDB . . . . . . . . . . . . . . . . 590