单选题Given the following RMAN commands,choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.()   a. restore database  b. recover database  c. shutdown immediate  d. startup  e. restore archivelog 

题目
单选题
Given the following RMAN commands,choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.()   a. restore database  b. recover database  c. shutdown immediate  d. startup  e. restore archivelog all f. alter database open
A

 a, b, c, d, e, f

B

 c, b, a, d, e, f

C

 c, b, a, d, f

D

 c, a, b, d

E

 c, a, e, b, d, f

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

第1题:

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

第2题:

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

第3题:

A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:Which is the recommended sequence of operations you need to perform for the query successfully?()

A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.

B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.

C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.

D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.


参考答案:C

第4题:

Given the following RMAN commands,choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.()   a. restore database  b. recover database  c. shutdown immediate  d. startup  e. restore archivelog all f. alter database open 

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

正确答案:E

第5题:

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

第6题:

A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?()

  • A、Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. 
  • B、Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. 
  • C、Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
  • D、Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 

正确答案:C

第7题:

You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database:  SET UNTIL TIME = ’2000-12-09:11:44:00’;  RESTORE DATABASE; RECOVER DATABASE;  How should the commands be executed? ()

  • A、Only the SET command must be within a RUN block.
  • B、All commands should be executed at the RMAN prompt.
  • C、All three commands must be within a single RUN block.
  • D、Only the RESTORE and RECOVER commands must be within a single RUN block.

正确答案:C

第8题:

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

第9题:

You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?()   a. restore controlfile until time `09/30/2008:18:00:00’ b. restore database until time `09/30/2008:18:00:00’  c. restore spfile until time `09/30/2008:18:00:00’ d. recover database until time `09/30/2008:18:00:00’ e. alter database open resetlogs f. alter database open

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

正确答案:A

第10题:

What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?()   a. sql ’alter database datafile 4 online’ b. restore datafile 4 c. recover datafile 4  d. sql ’alter database datafile 4 offline’ e. startup  f. shutdown

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

正确答案:B

更多相关问题