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 host

C、 by using the RMAN duplicate command with dbid and set newname 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***u6提供分享举报纠错

相关试题

单选题 You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your
UNIX-based Oracle 12c database: CONNECT /AS SYSDBA
ALTER SYSTEM SET THREADED EXECUTION= TRUE SCOPE=SPFILE; SHUTDOWN IMMEDIATE
You then restart the instance and get an error: STARTUP
ORA-01031: insufficient privileges
Why does the startup command return the error shown?

A、because the threaded architecture requires exiting from sql*pIus and reconnecting with sql*PIus /as sysdba before issuing a startup command

B、because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command

C、because the threaded architecture requires authentication using a password file before issuing a startup command

D、because the threaded architecture requires connecting to the instance via a listener before issuing a startup command

E、because the threaded architecture requires restarting the listener before issuing astartup command

查看答案

单选题 You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure. You want to recover the data file.
Examine the steps involved in the recovery process:
1Shut down the database instance.
2Start up the database instance in nomount state.
3Mount the database.
4Take the data file offline.
5Put the data file online.
6Restore the control file.
7Restore the database.
8Restore the data file.
9Open the database with the resetlogs option.
10Recover the database with the no redo option.
11Recover the data file with the no redo option. Identify the required steps in the correct order.

A、 4, 8, 11, 5

B、 1, 3, 8, 11, 9

C、 1, 2, 6, 3, 7, 10, 9

D、 1, 3, 7, 10, 9

E、 1, 2, 6, 3, 8, 11, 9

查看答案

单选题 You are administering a multitenant container database (CDB) cdb1. Examine the command and its output:
SQL>show parameter file
NAME TYPE VALUE
-----------------------------------------------------------------------
Db_create_file_dest string db_file_name_convert string
Db_files integer 200
You verify that sufficient disk space is available and that no file currently exists in the
‘/u0l/app/oracle/oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by using the command: SQL>CREATE PLUGGABLE DATABASE SALESPDB
ADMIN USER salesadm IDENTIFIED BY password ROLES=(dba) DEFAULT TABLESPACE sales
DATAFILE '/u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf’ SIZE 250M AUTOEXTEND ON
FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/cdb1/pdbseed/', '/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE 2G)
PATH_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';
Which statement is true?

A、SALESPDB is created and is in mount state.

B、PDB creation fails because the DB_file_name_convert parameter is not set in the CDB.

C、SALESPDB is created and is in read/write mode.

D、PDB creation fails because a default temporary tablespace is not defined for SALESPDB.

查看答案

单选题 You are administering a multitenant container database (CDB) that contains multiple
Pluggable databases (PDBs). You are connected to cdb$root as the sysuser. You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;
SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;
SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;
Which statement is true about the c##connect role?

A、It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

B、It is granted to the c##admin user only in theCDB.

C、It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

D、It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

查看答案

单选题 You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs). You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs. What is the easiest way to perform capacity planning for consolidation?

A、capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

B、capturing the workload on the production system and replaying the workload for one PDB at a time on the test system

C、capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

D、capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the testsystem

查看答案

单选题 You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

A、Corrupted blocks, if any, are repaired in the backup created.

B、Only those data files that have corrupted blocks are backed up.

C、Corrupted blocks in the data files are checked and repaired before performing the database backup.

D、 The database is checked for physically corrupt blocks and any corrupted blocks are repaired.

查看答案

单选题 Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:
SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users QUOTA 100M ON users TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

A、The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.

B、The command succeeds only if all the PDBs have the users and temp tablespaces.

C、The command gives an error because the container=all clause is missing.

D、The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tablespace does not exist in that PDB. 答案:

查看答案

单选题 Examine the command:
$expdp SYSTEM FULL=Y DUMPFILE=dpump_dir1:full1%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.dmp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull
Which statement is true about the execution of the command?

A、It fails because the log file parameter is not specified.

B、It fails because no absolute path is specified for the log file and dump file.

C、It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.

D、It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.

查看答案