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