多选题Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps s

题目
多选题
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?()
A

Mount the container database (CDB) and restore the control file from the control file auto backup.

B

Recover and open the CDB in NORMAL mode.

C

Mount the CDB and then recover and open the database, with the RESETLOGS option.

D

Open all the pluggable databases.

E

Recover each pluggable database.

F

Start the database instance in the nomount stage and restore the control file from control file auto backup.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?()

A. Mount the container database (CDB) and restore the control file from the control file auto backup.

B. Recover and open the CDB in NORMAL mode.

C. Mount the CDB and then recover and open the database, with the RESETLOGS option.

D. Open all the pluggable databases.

E. Recover each pluggable database.

F. Start the database instance in the nomount stage and restore the control file from control file auto backup.


参考答案:C, D, F

第2题:

Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.The steps to recover the tablespace are as follows:1. Mount the CDB.2. Close all the PDBs.3. Open the database.4. Apply the archive redo logs.5. Restore the data file.6. Take the SYSAUX tablespace offline.7. Place the SYSAUX tablespace online.8. Open all the PDBs with RESETLOGS.9. Open the database with RESETLOGS.10. Execute the command SHUTDOWN ABORT.Which option identifies the correct sequence to recover the SYSAUX tablespace?()

A.6,5,4,7

B.10,1,2,5,8

C.10,1,2,5,4,9,8

D.10,1,5,8,10


参考答案:A

第3题:

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN > BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command?()

A. Place the root container in ARHCHIVELOG mode.

B. Take the user data tablespace offline.

C. Place the root container in the nomount stage.

D. Ensure that HR_PDB is open.


参考答案:D

第4题:

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()

  • A、Restore and recover the datafile. 
  • B、Restore and recover the tablespace. 
  • C、Restore and recover the database. 
  • D、Restore and recover the control file. 
  • E、Restore and recover the parameter file.

正确答案:A

第5题:

You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?()   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database. 

  • A、a, b, f, g
  • B、c, f, g
  • C、a, d, f, g
  • D、a, f, g
  • E、a, e, g

正确答案:E

第6题:

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?()

A. Data files that belong to only the root container

B. Data files that belong to the root container and all the pluggable databases (PDBs)

C. Data files that belong to only the root container and PDB$SEED

D. Data files that belong to the root container and all the PDBs excluding PDB$SEED


参考答案:B

第7题:

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()  

  • A、 Restore and recover the datafile.
  • B、 Restore and recover the tablespace.
  • C、 Restore and recover the database.
  • D、 Restore and recover the control file.
  • E、 Restore and recover the parameter file.

正确答案:A

第8题:

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?()

A. Use Oracle Managed Files (OMF).

B. Specify the SEED FILE_NAME_CONVERT clause.

C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.

D. Specify the DB_FILE_NAMECONVERT initialization parameter.

E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).


参考答案:A, B, C

第9题:

Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()

  • A、You need to perform the restore and recover operations manually, because the backup was made manually. 
  • B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
  • C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
  • D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

正确答案:C

第10题:

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?()

  • A、Use Oracle Managed Files (OMF).
  • B、Specify the SEED FILE_NAME_CONVERT clause.
  • C、Specify the PDB_FILE_NAME_CONVERT initialization parameter.
  • D、Specify the DB_FILE_NAMECONVERT initialization parameter.
  • E、Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

正确答案:A,B,C

更多相关问题