You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. ()(Choose two.)
AReregistering the target database in recovery catalog
BTransporting the new tablespaces to the recovery catalog database
CSyncronizing the recovery catalog with the target database control file
DPerforming a fresh backup of the target database to include the new data files in the catalog database
相关问题推荐
-
During the installation of Oracle Database 11g,you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?()
A、 The installation terminates with an error.
B、 The installation proceeds with the default value without warnings and errors.
C、 The installation proceeds with the default value but it would not be an OFA-compliant database.
D、 The installation proceeds with the default value but a message would be generated in the alert log file.
-
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?()
AIt does not allow you to change the moving window size.
BAdaptive threshold functionalities use it by default to compute statistics.
CIt is created by default with the window size being equal to the AWR retention time.
DIt is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
-
What RMAN command is used to execute a tablespace point-in-time recovery?()
A、 recover
B、 duplicate
C、 restore
D、 copy
E、 None of the above
-
Evaluate the following command: SQL> CREATE TABLE design_data (id NUMBER, doc CLOB) LOB(doc) STORE AS SECUREFILE(DEDUPLICATE); Which statement is true regarding the above command?()
A、 The LOB values are automatically compressed.
B、 The LOB values are cached by default in the buffer cache.
C、 The LOB values are automatically stored in encrypted mode.
D、 All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
-
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?()
A、Perform Export before TSPITR and Import after TSPITR
B、Move objects to another schema that has the same tablespace assigned
C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)