A database instance uses an SPFILE, Examine the parameter:
NAME TYPE VALUE
control_files string /u01/app/oracle/oradata
You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2. Issue ALTER SYSTEM SET CONTROL FILES=
3. Issue ALTER SYSTEM SET CONTROL_FILES=
4. Copy the control file from the existing location to
5. Mount the database.
6. Open the database.
Identify the required steps in the correct order to accomplish the task.
You create a new database by using the CREATE DATABASE command in SQL *PLUS, with the ENABLE PLUGGABLE DATABASE clause specified.
Which statement is true about the database that is created?
You plan to duplicate multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:
RMAN> DUPLICATE TARGET DATBASE TO cdbdup
PLUGGABLE DATABASE sales
FROM ACTIVE DATABASE
Which two statements are true?
Examine the RMAN command:
RMAN> RUN (
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
INCREMENTAL LEVEL = 0
(DATAFILE 1,4,5 CHANNEL c1)
(DATAFILE 2,3,9 CHANNEL c2)
(DATAFILE 6,7,8 CHANNEL c3);
SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’;
Which statement is true about the command?
Which three statements are true about common roles?
You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table?
You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability.
In which three situations must you use a recovery catalog?
Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database.
Identify the required steps in the correct order.
Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode?