违法和不良信息举报 联系客服
免费注册 登录

You performed the RMAN database

题目

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMAN>CHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?（）

  • A、The backup is deleted.
  • B、The backup is marked unavailable.
  • C、The backup overrides the backup retention policy.
  • D、the backup becomes eligible for deletion according to the existing retention policy
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).

A. The backup as copy can only be taken to disk

B. The backup as copy can only be taken to tape

C. Backup can be performed only when the instance is shutdown

D. Backup will constitute all used and unused blocks in the database


参考答案：A, D

第2题：

You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）

  • A、A backup of the target database when it is mounted
  • B、A backup of online redo log files when the database is open
  • C、A backup of only used data blocks in the file beingbeingbackup up
  • D、A backup of online， read/write data files when the database is open
  • E、A backup of only those data blocks that have changed since a previous backup
  • F、A backup of online， read/write data files when the database is in the NOMOUNT state.

正确答案:A,C,D,E

第3题：

After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()

A. Opening the database in RESTRICTED mode

B. Opening the database with the RESETLOGS option

C. Setting a new DBID for the newly restored database

D. Restoring the server parameter file (SPFILE) to the new host


参考答案：B

第4题：

You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

  • A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
  • B、 When a structural change is made to the database， then a backup of the current control file is performed.
  • C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
  • D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

正确答案:D

第5题：

RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

  • A、’SQL ALTER DATABASE OPEN’；
  • B、SQL ALTER DATABASE ’OPEN’；
  • C、OPEN DATABASE；
  • D、DATABASE OPEN

正确答案:C

第6题：

You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN >BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

A. Corrupted blocks, if any, are repaired.

B. Checks are performed for physical corruptions.

C. Checks are performed for logical corruptions.

D. Checks are performed to confirm whether all database files exist in correct locations

E. Backup sets containing both data files and archive logs are created.


参考答案：B, D

第7题：

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

第8题：

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()

A. The backup as copy can only be taken to disk

B. The backup as copy can only be taken to tape

C. Backup can be performed only when the instance is shutdown

D. Backup will constitute all used and unused blocks in the database


参考答案：A, D

第9题：

It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）

  • A、cannot be used in RMAN
  • B、by starting up the database again
  • C、by using the CATALOG command of RMAN
  • D、by using the RECOVER CATALOG command in RMAN
  • E、by re-creating the target control file to rebuild the RMAN repository

正确答案:C

第10题：

You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）

  • A、 rman TARGET / NOCATALOG
  • B、 rman TARGET sys/password
  • C、 rman TARGET sys/password AS SYSDBA
  • D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

正确答案:B

更多相关问题
相关内容