Which of these recommendations should be followed before capturing a workload? (Choose
all that apply.)
A.
Make sure your replay database has the same structure as the capture database, except
without data.
B.
Make sure the replay and capture databases are similar in data content.
C.
Perform a clean shutdown and restart of the capture database before beginning a
workload capture.
D.
Start the capture database in UNRESTRICTED mode, then start the capture.
E.
Define inclusion and exclusion filters.
B and C are correct:
https://docs.oracle.com/cd/B28359_01/server.111/e12253/dbr_capture.htm
B: Before starting a workload capture, you should have a strategy in place to restore the database on the test system. Before a workload can be replayed, the state of the application data on the replay system should be similar to that of the capture system when replay begins. To accomplish this, consider using one of the following methods:
Recovery Manager (RMAN) DUPLICATE command
Snapshot standby
Data Pump Import and Export
This will allow you to restore the database on the replay system to the application state as of the workload capture start time.
C: Before restarting the database, determine an appropriate time to shut down the production database prior to the workload capture time period when it is the least disruptive.
Overall steps:
Only one workload capture can be performed at any given time. If you have a Oracle Real Application Clusters (RAC) configuration, workload capture is performed for the entire database. To enable a clean state before starting to capture the workload, all the instances need to be restarted. You can do this by:
Shutting down all the instances.
Restarting one of the instances.
Starting workload capture.
Restarting the rest of the instances.