Your production database is running

单选题

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?

A、

by using the RMAN switch command to set the new location for the data files

B、

by using the RMAN duplicate command with nofilenamecheck to recover the database to the new hostRMAN duplicate nofilenamecheck

C、

by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host

D、

by creating a new database in the new host, and then using the RMAN recover command

查看答案

下载APP答题

由4l***ds提供分享举报纠错

相关试题

单选题 SQL Performance Analyzer (SPA. has reported several regressed SQL statements for one of your databases.Which action could help in the performance management of these regressed SQL statements?

A、Create SQL plan directives for each of the regressed statements.

B、Use The SQL Tuning Advisor for each of the regressed statements.

C、Create an adaptive execution plan for each of the regressed statements.

D、Use the SQL Access Advisor for each of the regressed statements.

查看答案

单选题 You plan to create a database by using the Database Configuration Assistant (DBCA., with the following specifications:
Applications will connect to the database via a middle tier. The number of concurrent user connections will be high.
The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?

A、a General Purpose database template with default memory allocation

B、a Data Warehouse database template, with the dedicated server mode option and AMM enabled

C、a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

D、a default database configuration

查看答案

单选题 You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.You execute the following command to change the requirement:SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;What is the outcome?

A、All historical data older than two years, if any, is purged from the flashback archive FDA1.

B、An error is returned because the retention period cannot be reduced.

C、All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years.

D、All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

查看答案

单选题 A user complains about poor database performance.You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

A、V$SESSION_EVENT

B、V$SESSTAT

C、V$SESSION_WAIT

D、V$SESSION_WAIT_CLASS

E、V$SESSION

查看答案

单选题 Examine the statements that use flashback technologies:

1.FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');

2.SELECT * FROM customers AS OF SCN 123456;

3.FLASHBACK TABLE customers TO BEFORE DROP;

4.FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');

5.SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;

6.ALTER TABLE customers FLASHBACK ARCHIVE;

Which set of statements depends on the availability of relevant undo data in the undo tablespace?

A、1,3,6

B、1,2,5

C、3,4,5

D、2,3,5,6

查看答案

单选题 choose one You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

A、The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

B、The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

C、The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

D、The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

查看答案

单选题 You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage.

Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: DUP_DB。

RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE;

What is a prerequisite for the successful execution of this command

A、RMAN must be connected to the target database instance and the auxiliary instance.

B、A most recent backup set of the PROD database must exist.

C、Flashback must be enabled for the PROD database

D、The target database must be in MOUNT state.

查看答案

单选题 Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

A、Run the SQL Access Advisor.

B、Run the Memory Advisor for the shared pool.

C、Run the SQL Tuning Advisor.

D、Run the Memory Advisor for the Program Global Area.

E、Run the Memory Advisor for the System Global Area.

查看答案